Spaces between values when using IN expression
Grimfellow
Posts: 4 New member
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!
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!
Tagged:
Answers
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