Skip to Content
0
Former Member
Feb 09, 2011 at 10:08 AM

Mapping Logic needed

12 Views

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