How can we help you today? How can we help you today?

Copy as IN Clause without Unicode prefix?

Is there a setting to stop SQL Prompt from prefixing strings in the "Copy as IN Clause" list with N?

Ex: I'm trying to get 
('abc',
'def',
'ghi')

instead of 
(N'abc',
N'def',
N'ghi')

Thanks!

TJSmith
0

Comments

1 comment

Sort by
  • Kurt_M
    Hi @TJSmith,

    I'm afraid there's no setting to control the "Copy as IN clause" in the options menu, as it works off of the type of data you're copying from. For example, if you use this copy function on a column listed as nvarchar, then it will affix the N before the value. However, if the column is a varchar, it will list the value without the N before it. 

    If changing the datatype is an option, you could adjust it from a unicode data type to something else.
    Kurt_M
    0

Add comment

Please sign in to leave a comment.