syntax for 'where field contains 'string'' 1

[almoes]

Hi all!

I am trying to figure out the proper syntax for the following:

Select * from myDB where myField contains ('181')

I need to retrieve all rows where the field contains 181.
Thanxs.

cheers,
alej

 

[john76]

Try:

SELECT  *
  FROM    myDB..myTable
  WHERE   myField [COLOR=maroon]LIKE '%181%'[/color]

This will select all rows where myField contains the string 181 somewhere in the text.

Hope this helps,
John

 

[almoes]

Cool it works! Thanxs!

 

[john76]

Glad I could help.

A couple of notes to add to this, the % wildcard will substitute any number of characters wherever it is placed, while the _ (underscore) wildcard substitutes a single character.

You can also use sets and ranges of characters by enclosing them in brackets ([ ]).

ex: WHERE SSN LIKE '123-45-[0-9][0-9][0-9][0-9]'
gives all variations of SSN beginning with 123-45- and ensuring that the following characters are actually digits.

John

 

[almoes]

even cooler! ;-)