# Decimal Delimiter

In Europe the decimal delimiter is often set to be comma character. DB2 database configured this way will return SQL syntax error in the following cases:

- select ....,1,
- insert ....values(...1,2,3...)
- insert ....values(...1 ,2,...)
- order by 1,2,3
- order by 1 ,2
- update...set abc=1,def='XX'
- case (? as varchar(50),12

To avoid this problem, surround the comma with spaces.

Parent topic: SQL statements to avoid