Hi Mike ...
thanks for taking the time ... after your example ... it freed up my mind to have a close look at what I was doing. I change the storage options to Indexing *minimal and austomatically index. As well the calculation result for the text field was Number ... seems Filemaker is very forgiving as it calculated ok for me in filemaker BUT not in SQL.
Thanks for taking the time as it allowed me to stop thinking incorrectly and open my eyes AWESOME!
The problem was probably the field type. Glad you got it sorted.