SQL query advice .. writing a query with pattern matching
Folks,
I have a column in MSSQl table as below:
| email |
-----------
suzuki@amc.com
yamaha@abc.co
harley@cbc.com
....
I want to write a query that will replace everything before the '@' in all
the fields with a single work "cars". so the column should look:
| email |
-----------
cars@amc.com
cars@abc.co
cars@cbc.com
....
Any advice on how I can form this query ?
No comments:
Post a Comment