How to fetch records which has "xxxx" middle value in a field

[savi]

Hi guys,

I have a table with 3000 records and I have to fetch records only has particular value like "xxxx" in a character field.
That "xxxx" is anywhere in the place of that field value like "abcddxxxxtuelkj" , "abcxxxxeoeieo", "peiwodjxxxx" and so on.
for eg : table has fields, field1, field2, field3. I have to search in field3 whichever has inside string value "xxxx".
Please give me solution if you have any.
Thanks

 

[osjohnm]

Hi

You could try this:

select field1, field2, field3
from table
where field3 like '%xxxx%'

Hope that helps
John

 

[MeanGreen]

Try this:

Select * from table
where CHARINDEX('xxxx', field3) > 0

Hope this helps.