Member Avatar for mokshi

Hi,
I want to remove leading zeros in sql with a query,i tried this but it doesnt work,please help me out
my column name is=empid like 00000001,00000023,00000534 i want to remove this leading zeros and check this with another table empid

thanks in advance

  • 2 Contributors
  • 1 Reply
  • 97 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by Alberto Bucur
Member Avatar for Alberto Bucur

When MYSQL does the math it zaps the leading zeroes auto-magically.

select empid*1 as empid from table
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.