Connecting Tech Pros Worldwide Forums | Help | Site Map

How to remove the "." present only at the start

Newbie
 
Join Date: Nov 2008
Location: Bangalore, India
Posts: 1
#1: Nov 1 '08
Hi All,
Please help me out with this,

I have a column with the data ".0.7657", now I have to remove "." present only at the beginning of the data and I have to retain the other "."

Thanks,
Nag

ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#2: Nov 2 '08

re: How to remove the "." present only at the start


Try this:

Expand|Select|Wrap|Line Numbers
  1. select substring('.0.7657',2,20)
  2.  
-- CK
Reply