Quick Fix: How to TRIM and CONVERT ???

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  February 10, 2004 at 8:50 am

  #107628

  Hi,

  How do I .... Before inserting data into a column, I need to first convert the type from varchar to numeric (so that I can perform calculations) and TRIM everyting after a blank is detected, including the blank. ie: '1024 KB' ---> 1024 

  Any quick code help is greatly appreciated. Thanks, Jeff

  Many thanks. Jeff

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  February 10, 2004 at 9:05 am

  #493406

  SELECT LEFT(YourCol,CHARINDEX(' ',LTRIM(YourCol)))

  WHERE LTRIM(YourCol) LIKE '% %'

  
  
  --Jonathan