What are the challenges you face when working across database platforms? Take the survey

Spaces between values when using IN expression

GrimfellowGrimfellow Posts: 4 New member
edited August 10, 2022 6:45PM in SQL Prompt
 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!



Sign In or Register to comment.