Simple Select Statement

[hamtaro^-^]

Hi guys can you please take a look at this

Below is my sample script

DECLARE @sku nvarchar(100)
SELECt @sku = sku from ac_orderItems  where orderID = 12 and orderItemTypeID = 0
Print @sku

Then when i print @sku it give me a result of SampleB
but i want to produced an output of 'SampleB' enclosed in a single quote.

Thanks

[abhijit]

Hi guys can you please take a look at this

Below is my sample script

DECLARE @sku nvarchar(100)
SELECt @sku = sku from ac_orderItems  where orderID = 12 and orderItemTypeID = 0
Print Chr(39) || @sku || chr(39) 

Then when i print @sku it give me a result of SampleB
but i want to produced an output of 'SampleB' enclosed in a single quote.

Thanks

Will that work?

[GaryMazzone]

For SQL Server change || to +

[dee-u]

'chr' is not a recognized function name, use char instead.

Print char(39) + @sku + char(39)

[brucevde]

SQL Server has a string function called QuoteName. The syntax is

QUOTENAME ( 'character_string' [ , 'quote_character' ] )

'quote_character' can be a single quotation mark ('), a left or right bracket ([] - default), or a double quotation mark (").

DECLARE @sku nvarchar(100)
SELECt @sku = QuoteName(sku,'''') from ac_orderItems  where orderID = 12 and orderItemTypeID = 0
Print @sku

[abhijit]

For SQL Server change || to +

'chr' is not a recognized function name, use char instead.

Print char(39) + @sku + char(39)

This is how Microsoft confuses PL/SQL developers.