View Single Post
  #4 (permalink)  
Old 03-06-2007, 02:30 AM
diego
 
Posts: n/a
Default T-SQL answer. Re: How can I find fields that have a substring in common?

use the "like" comand
[sql]
SELECT string FROM table where string like '%' + @substringTocompare + '%'
[/sql]


where the special character '%' is a comodin for find all substring similary.
Reply With Quote