Need to run a query to find all the items that contain a + sign I don't know the syntax/symbol to use in the query for "contains"
Can anyone help me on that?
select * from item where lookupcode (contains)+
- posted
16 years ago
syntax for "contains"
Loading thread data ...
- Vote on answer
- posted
16 years ago
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
- Vote on answer
- posted
16 years ago
- Vote on answer
- posted
16 years ago
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....