What is the datatype of this column?

-----Original Message-----
From: Indra Timilsina
[mailto:mssqldba-ezmlmshield-x88645132.[Email address protected]
Sent: Thursday, March 30, 2006 12:14 PM
To: LazyDBA Discussion
Subject: updating records

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.









---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page