SQL String manipulation

fogyan

New member
Local time
Today, 14:21
Joined
Sep 21, 2009
Messages
1
hi,
How do I replace all the substrings that begin with 'b' (space delimited string) with '###' ?
Example:
Original string: "My brother is a big bad wolf"
Manipulated string: "My ### is a ### ### wolf"
Thanks!
 
Well you would have to make your own function to do this, something like:
Search for " b" (note the space) to find anything that starts with a b.
Then replace the entire word (up to the next space)
Rinse and repeat

P.S. Welcome to AWF
 

Users who are viewing this thread

Back
Top Bottom