How can I update record on the table having following condition.



Update only record on column say "Col008" which contain number without
decimal point and put decimal point in front of number and donot update
in it contain number with decimal



Like





Col008 has following values:



34

2.65

8.11

65

14

7.32

65



It should update to

0.34

2.65

8.11

0.65

0.14

7.32

0.65



If any one has information, please let me know.



Thanks.








MS Sql Server LazyDBA home page