Login     Register

        Contact Us     Search

XLeratorDB/strings Online Documentation

SQL Server QUOTED function


QUOTED

Updated: 30 April 2009


Use QUOTED to add quotation marks (CHAR(34)) to the beginning and end of a string of text.
Syntax
SELECT [wctString].[wct].[QUOTED] (
   <@Text, nvarchar(max),>)
Arguments
@Text
is the text value to be evaluated. The @Text argument can be of data types that are implicitly convertible to nvarchar or ntext.
Return Types
nvarchar(max)
Remarks
·         To add single quotes (CHAR(39)), use the QUOTES function.
Examples

select
wct.QUOTED('now is the time for all good men to come to the aid of their country')
 
This produces the following result
-----------------------------------------------------------------------
"now is the time for all good men to come to the aid of their country"
 

(1 row(s) affected)



Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service