inserting decimal point

• AMIT GUPTA-263376

  SSCarpal Tunnel

  Points: 4244

  More actions

  February 10, 2006 at 7:57 am

  #620133

   

  USE THIS SIMPLE qUERY???

   

  select REPLACE(substring('V4567',1,3) + SPACE(1) + SUBSTRING('V4567',4,LEN('V4567')),' ','.')

   

   

• G.Mohr

  Grasshopper

  Points: 10

  More actions

  February 10, 2006 at 10:14 am

  #620221

  Try it with just this simple TSQL code.

  select SUBSTRING(vfield,1,3) + '.' + SUBSTRING(vfield,4,6) from yourtable

  For example using string '111':

  select SUBSTRING('111',1,3) + '.' + SUBSTRING('111',4,6)

  returns: 111.

  ---

  Kindest Regards,

  G. Mohr