select top 70 * FROM Comments c WITH (NOLOCK) where lowe...

1

Please login or register to vote for this query.

(click on this box to dismiss)

Tridion Meta

Q&A about the site for Tridion developers and administrators

select top 70  *
FROM Comments c WITH (NOLOCK)
where lower(Text) like '%thank you%' 
and CreationDate > '2020-07-25'
AND len(Text) < 45
order by ID

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results