I have a field in a union query the has this format, I believe it is a string data type because the last two se room come from short text fields.
#####-ttt-ttt, the t,s are the text fields although they are usually numbers from a short text data field both the text fields vary in length and for some records the last part of the field is non-existent. Will it be easy to separate because they are from field from different tables?
#####-ttt-ttt, the t,s are the text fields although they are usually numbers from a short text data field both the text fields vary in length and for some records the last part of the field is non-existent. Will it be easy to separate because they are from field from different tables?