Member Avatar for achiman

Can anyone tell me what data type I can use to store an numbers of this sort "087699" I want it to store the FIRST ZERO. If I use INT or double it removes the first zero

  • 3 Contributors
  • 3 Replies
  • 99 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by WebspoonUK
Member Avatar for achiman

its solved

Member Avatar for drjohn

looks like a phone number.
so it's NOT a number, it's a string.
Any other data-type is wrong.

Member Avatar for WebspoonUK

Quick anwser - you can't

You have to store any number starting with a '0' as a string as the datatype will remove it if you store it as a numerical data type.

Edited by WebspoonUK because: spelling mistake
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.