B
Bombay
I am running a query that grabs information from a field in a table.
That field can have numerical value or character value.
When it is numerical, it looks like 0000034567
I want to truncate the numerical to just the last 5 digits.
If it is character based, it will be like M12-BR4810, in which case I do not
want it truncated at all.
Anyone know how I would do this in a query for the results?
That field can have numerical value or character value.
When it is numerical, it looks like 0000034567
I want to truncate the numerical to just the last 5 digits.
If it is character based, it will be like M12-BR4810, in which case I do not
want it truncated at all.
Anyone know how I would do this in a query for the results?