Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Search query probelm
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 5th November 20:39
hilary cotter
External User
 
Posts: 1
Default Search query probelm


do this search

select LongDescription From MatText where CONTAINS
(LongDescription, ' "VAL" ')

and then
select LongDescription From MatText where LongDescription
like '%VAL%'

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.

Also try

select LongDescription From MatText where LongDescription,
like 'VAL'
which should be the functional equivalent of the contains.
  Reply With Quote


  sponsored links


2 5th November 20:40
john kane
External User
 
Posts: 1
Default Search query probelm


Keny,
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
searching against?
Regards,
John
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666