How to use Replace function in sql server:

SQL server 2008 is most usefull date base among many now in this post we will learn about how to use Replace function in SQL Server 2008 Replace function is use for the replace the spacific string from the given stringas show below

/////////////////////////////////////////////////
declare @str varchar(50)
select @str='Hi Welcome to my blog -Nirav daraniya'
select @str
select REPLACE(@str,'to my','this')
//////////////////////////////////////////////////

OUTPUT:


See Also :

• how to crack IDM
• How to change name of start button in xp
• how to connect to facebook without Internet connec...
• How to customize send to menu.
• How to hide folder without any software.

  Follow Me On Facebook

--
/\/ir@\/  <(.'.)>