on 02-09-2011 10:08 AM
Dear Frnds,
I have a field name Area, its maximum size is 4 ..
if it contains 2 numbers i can stuff other 2 numbers as Zeros using FORMAT NUM fn.
But if the field is alpha numerical it has to passed as it is.. and if it is numbers the above logic has to be applied..
how to acheive both of them
any stndrd fn or UDF is needed?
Edited by: prabhas465 on Feb 9, 2011 11:46 AM
Hi,
You need to write a UDF to achieve the requirement. There is no standard function to validate this condition and pass the value.
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.