Newbie question on replace
From: moido10025 (anonymous_at_discussions.microsoft.com)
Date: 08/31/04
- Next message: Joe Celko: "Re: IN Clause - Stuck on an easy query :-("
- Previous message: oj: "Re: returning error from sp using sp_executesql"
- Next in thread: David Portas: "Re: Newbie question on replace"
- Reply: David Portas: "Re: Newbie question on replace"
- Reply: David Portas: "Re: Newbie question on replace"
- Reply: David Portas: "Re: Newbie question on replace"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 31 Aug 2004 14:53:13 -0700
I am trying to replace a text string using like but can't
seem to get it to work. SQL won't accept the first
instance of like. What I have so far:
update note
set contact_1 like '%, %' where contact_1 like '%&%'
Any help would be greatly appreciated.
- Next message: Joe Celko: "Re: IN Clause - Stuck on an easy query :-("
- Previous message: oj: "Re: returning error from sp using sp_executesql"
- Next in thread: David Portas: "Re: Newbie question on replace"
- Reply: David Portas: "Re: Newbie question on replace"
- Reply: David Portas: "Re: Newbie question on replace"
- Reply: David Portas: "Re: Newbie question on replace"
- Messages sorted by: [ date ] [ thread ]