Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 String Search

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-31 : 22:57:39
Sam writes "Hi,

I have the following query:

select * from emp_mast where emp_mailid like '%@yahoo.com%'

the '@yahoo.com' needs to replaced by '@hotmail.com' globally.

How will I write a query to achieve the same.


Thanks in advance"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-31 : 22:57:39
Maybe like this - http://www.sqlteam.com/item.asp?ItemID=7386
Go to Top of Page
   

- Advertisement -