SQL Replace Function for Strings
From: Michael (anonymous_at_discussions.microsoft.com)
Date: 06/06/04
- Previous message: Nikhil: "how do i create a view within a procedure that uses a variable defined in the procedure"
- Next in thread: Michael: "RE: SQL Replace Function for Strings"
- Reply: Michael: "RE: SQL Replace Function for Strings"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 6 Jun 2004 02:16:02 -0700
Hi all
I have a colum with values likes this 2345:Text. The number behind the colon is always different. I want to remove the colon and the numbers behind the colon. Actually I would use the following statment: select *, replace (Colum1, '2345:','').
There seem to be no wildcards possible for the function REPLACE. Does anyone have a solution for this? I'm using Windows SQL 2000 Server.
Thanks
Michael
- Previous message: Nikhil: "how do i create a view within a procedure that uses a variable defined in the procedure"
- Next in thread: Michael: "RE: SQL Replace Function for Strings"
- Reply: Michael: "RE: SQL Replace Function for Strings"
- Messages sorted by: [ date ] [ thread ]
