Hilary cotter 2011-11-05 20:39:02
do this search
select LongDescription From MatText where CONTAINS
(LongDescription, ‘ “VAL” ‘)
select LongDescription From MatText where LongDescription
I suspect that you have a word like BYVAL somewhere in
longdescription that is showing up in the like and not in
the contains query.
select LongDescription From MatText where LongDescription,
which should be the functional equivalent of the contains.
John kane 2011-11-05 20:40:53
What exact SQL Server version and on what OS platform (NT 4.0 or Win2K or
WinXP or Win2003) is it installed?
Post the full output of: SELECT @@version
Also, could you post the actual data/text in the column that your are