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

Spaces between values when using IN expression

Greetings, can someone advise how I can format an IN operator to exclude any spaces between the values as seen below? I checked the formatting style and currently the setting for add a space around IN contents is unchecked.

After formatting the below is what is produced:

WHERE NumberID IN ('705.5780', '705.5765', '705.5820', '705.5762', '705.5840', '704.0218', '705.5870', '705.5760', '705.5851', '705.5852')

It's creating a space between the comma and the beginning of the next value.

Thanks, appreciate any input!

Grimfellow
0

Comments

1 comment

Sort by
  • DustinM
    Hello,

    Unfortunately, it does not appear that SQL Prompt has the level of customization available to remove the spaces between the values.

    We are always looking for suggestions for new features and welcome you to add this as a recommendation for our development team to look into in our user's voice forum.

    https://redgate.uservoice.com/forums/94413-sql-prompt

    Best,

    Dustin

    DustinM
    0

Add comment

Please sign in to leave a comment.