fredley Posted April 26, 2007 Share Posted April 26, 2007 I am using the following: If((Right(NINumber;1) = "B" or Right(NINumber;1) = "A" or Right(NINumber;1) = "C" or Right(NINumber;1) = "D") and Length(i8) = 9;1;0) to determine whether or not the entry in the i8 field is an NI Number. It outputs a 1 for JN473791D but a 0 for SG584332A. Why? Link to comment Share on other sites More sharing options...
Inky Phil Posted April 26, 2007 Share Posted April 26, 2007 What is the relationship between NINumber and i8? Phil Link to comment Share on other sites More sharing options...
Søren Dyhr Posted April 26, 2007 Share Posted April 26, 2007 I thought was something you beat with some shrubbery like in: "Monty Python & the Quest for the Holy Grail" But the expression could be written this way: Position ( "abcde" ; Right ( NINumber ; 1 ) ; 1 ; 1 ) and Length(${8i})= 9 No need for iffing in vain, the ${ is due to the ignorance of the warnings made about propper naming of fields. --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6218 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now