Monday, 13 May 2013

Select Replace , Substring Using SQL

Select Replace , Substring Using SQL

//Select Title

   Select Title From Char_Index


//Replace G:

      Select REPLACE(Title,'g','oo') Title From Char_Index





//Substring

     Select SUBSTRING(content,101,60) as SubString From Char_Index where    
        ID=1










No comments:

Post a Comment