Posted by Jens on 01/12/06 21:26

Hi I donßt know if you mean that the column if of the type text or its
just a text column. Anyway, if you use wildcards you can use this
query:

Select *
>From SomeTable
Where SomeColumn LIKE '%777%'

HTH, jens Suessmeyer.

• Next in forum: Searching for a partial match in a varchar field
• Prev in forum: Re: selecting only numeric data from a string
• Thread view: Re: Searching for a partial match in a varchar field

[Reply to this message]