Filtering strings

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

What exactly do you mean, filter to remove from the string, filter to remove / include from a return set?

Denby Hall of Fame Points: 3120 More actions · Answer 2

Yes, i want it to be remove from the result set

Christopher Klein SSCrazy Points: 2648 More actions · Answer 3

well, you could do something like 'not in'

select names from list where names not in ('foo','bar','qwerty')

or

select names from list where names not in (select excludenames from filtertable)

Denby Hall of Fame Points: 3120 More actions · Answer 4

have you tested it with: in ('St. Ann's')

the extra apostrophe is causing the prob

David McFarland SSChampion Points: 11815 More actions · Answer 5

Denby, to put apostrophes in strings, you "escape" them by doubling them up.

Try:

in ('St. Ann''s')

Denby Hall of Fame Points: 3120 More actions · Answer 6

Hall of Fame

Points: 3120

April 19, 2007 at 12:02 pm

ok man thx