I have one column with values 01,02,03,87,89,98etc
I want to use match function. How to convert these numbers to string so that It will be easy for me to comparision.
Numeric to string
see if this is you need.
try with Text(Trim(Field))
Hope this helps.
you can use text(field) then the values will be converted to string.
If you have 01 you have yet a value in string format, try to add more details to your request
You can use text(number_field) to convert it to string.
If you want this number with the zeros in the left, you can use text(num(number_field,'00')). This way will keep, for example, "01".
Hope it helps.
Retrieving data ...