hello!

the scenario..... is i have a column, let say fieldx some of them have 10 characters that is 00000000a0 others are 8 characters 000000ao and i want the 8 char to be also 10 by adding additional 00? is this possible?


thanks...

The formula you want is:

iif(len(fieldx)=8, "00"&fieldx,fieldx)

Put this in an update query if you want a permanent change, or as a calculated field in a select query if you want the conversion 'on the fly'.