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