How in SQL would i go about converting from a Character to a String. The field is a character field, RefNo. RefNO can be a number, or a word, such as CASH. If it is a number then i need to be able to find the MAX of it in order to add one to it for the next RefNo, but if i do convert or cast it gives an error when it hits a character. Is there anything like VFP's VAL() function that will return a number if it can, but return 0 if it is characters?
Thanks