-- TO REMOVE ALL UNWANTED TERMS FROM THE STRING AND DISPLAY CHINESE , RUSSIAN AND ENGLISH, DUTCH, GERMAN.... CHARACTERS CREATE PROCEDURE [dbo] . [XXX] @UserName nvarchar ( 32 ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; Declare @strText as nvarchar ( 500 ) select @strText = Replace ( SearchText , N'^' , N'' ) from TABLENAME where UserName = @UserName ...