SQL Statement that searches the same column for multiple values

[jillallynwilson]

I need to search one field for multiple values. For example, user enters search query as 'apples and oranges'. The field lists the value a '1 apple, 2 grapes in oranges'.

Below is the statement that I am trying but I am not sure if the CONTAINS syntax is correct or even valid. I found this option on related T-SQL (Transact-SQL) sites and I am not sure of the difference between SQL and T-SQL.

SELECT * FROM LIB.FILENAME WHERE CWTYPE = 'M' AND CONTAINS(Ucase(CWFULLDESC), ' "APPLES" AND "ORANGES" ')

Should the above work, if not, do you know the correct statement to use.

 

[r937]

there's a huge difference between SQL and T-SQL

see SQL Server 2000 vs. ANSI SQL:1999 Functions (XLS)

try this --

SELECT * FROM LIB.FILENAME
WHERE CWTYPE = 'M'
AND UPPER(CWFULLDESC) LIKE '%APPLES%'
AND UPPER(CWFULLDESC) LIKE '%ORANGES%'


r937.com | rudy.ca