Mar 19, 2007 #1 kermitforney Technical User Joined Mar 15, 2005 Messages 374 Location 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?
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?
Mar 19, 2007 #2 bborissov Programmer Joined May 3, 2005 Messages 5,167 Location BG What type is the field? Borislav Borissov VFP9 SP1, SQL Server 2000/2005. MVP VFP Upvote 0 Downvote
Mar 20, 2007 #3 JBaileys Technical User Joined Jun 23, 2003 Messages 244 Location US Have you tried to compare it with left (variable, 5)? Upvote 0 Downvote