0

I am doing application for french based company, I need to store decimal value like(12,2) in MS sqlserever.I need to use comma(,) instead of (.) in decimal field.

user3222352
  • 11
  • 2
  • 3
    It is not stored as text. It is stored as numbers. You want to read it, and convert the decimal value to a string with commas. The `FORMAT` function would be great, but unfortunately it needs 2012+. See the answers to the duplicate question for a workaround. – Paul Draper Jan 22 '14 at 07:08

1 Answers1

0

Insert an encoder/decoder in your injection screening layer.

Alternatively, store your data as character sequence.

guest
  • 711
  • 1
  • 6
  • 11