syntax for "contains"

Hi Kathryn - depending on where the plus sign is try....

select * from item where itemlookupcode like '+%' (plus at beginning) select * from item where itemlookupcode like '%+%' (plus in middle of string) select * from item where itemlookupcode like '%+' (plus at end)

h> Need to run a query to find all the items that contain a + sign

That would definitely work, but I thought I would chime in with an alternate method. To to it in one statement, I would use the CHARINDEX() function. The following should find all items with a '+' in the itemlookupcode:

select * from item where charindex ('+', itemlookupcode) 0

Just my 2 cents.

"c> Hi Kathryn - depending on where the plus sign is try....