Query syntax for CONTAINS

[Andy Wilton]

I have a table with a string column and would like to issue a SELECT
statement that basically gives me all rows where the string column contains
'TEST'

I also would like to perform a similar select statement but where the string
column begins with 'TEST'

Any ideas ?

Thanks in advance

Andy Wilton

PS. MS SQL 7

[Bradley M. Small]

Try

--For contains 'TEST'
select * from MyTable where stringColumn like '%TEST%'

--For StartsWith 'TEST'
select * from MyTable where stringColumn like 'TEST%'

--For EndsWith 'TEST'
select * from MyTable where stringColumn like '%TEST'

-- Bradley

"Andy Wilton" <A...@profitmaster.co.uk> wrote in message
news:992595951.14112.0...@news.demon.co.uk...