Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple formatting question?

Status
Not open for further replies.

kermitforney

Technical User
Mar 15, 2005
374
0
0
US
Trying to make sure that every record in a specific column is a 5 digit numeric. Can't quite get the correct syntax down.

Any help?
 
What type is the field?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 

Have you tried to compare it with left (variable, 5)?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top