By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,045 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Remove Leading Zero's from table field

P: 1
Hi, I have used inner join but need to remove leading zero's in one of the field because my query is
"select * from table1 inner join table2 where table1.start = table2.start" here table1.start field consistleading zero's. how can i apply query in where condition to remove leading zero's.
Dec 23 '15 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,349
If the field is a string that holds only numbers, converting the field to an actual numeric data type will remove the leading zeroes.
Dec 23 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.