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 :
  Follow Me On Facebook

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

Comments

Post a Comment

Popular posts from this blog

How to get column value from the selected row in data grid in wpf c#.net

Image
Data grid is a control for display the data in tabular format in our application. In data grid when u select any row then for getting this rows unique id write code like : Ex : here we will take ‘ dgcustomer ’ as data grid with following column name (Id,Name,RollNumber,Pass)                         string strid = "" ;                          DataRowView rowview = dgcustomer.SelectedItem as DataRowView ;               strid = rowview.Row[ "Id" ].ToString(); MessageBox .Show( "ID : " + strid);
Read more

How to make and use web service in Microsoft Dynamics Navision.

Image
Web services is use to do operation on data of NAV from outside the NAV environment, you can’t insert, update, delete the data of NAV using web service with proper authentication. For creating the web service in NAV follow below steps. (Here we are making the web service with gives vendor name based on vendor number. And we consume this service in windows application outside the NAV area.) Open NAV development environment and create the new code unit. Make one function “GetVendorName” Function name: GetVendorName Input Parameter : VendorNumber Output (Return) parameter : VendorName Now write below code in function. IF Vendor.GET(VendorNo)THEN BEGIN     EXIT(Vendor.Name); END ELSE BEGIN     EXIT('Vendor Not Found'); END Now save this codeunit with proper Id and Name. Now open the client application module and search for ‘Web service’ in search text box.  Open the “Web service page” and click on “NEW” button, it will ask following details Object Type: Codeunit Obj...
Read more

How to use Format function in Microsoft Dynamics Navision.

Image
Format function is use to display date in various format some example given below. Format function take 3 input argument First: date which you want o display Second: number of character return by default is 0 (o means return all the string) Third: string format in witch you want to convert. Example: 1 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,'<Month Text> <Day,2> <Year4>')); OURPUT: Emaple:2 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,' <Day,2> <Month,2> <Year4>')); OUTPUT:
Read more