Maybe not so interesting, but at least curious, a little anomaly in RB
or my brain.
I have a table with a field, `TimeTXT` TEXT (18), which holds
text-values for elapsed time, in the form 'MM:SS'. I have just received
a set of data to import that also has the 'HH:' components. So, I
figured I'd just add the 'HH:' to the other strings, to make 'em all
uniform. In each and every instance, the actual value of 'HH:' is
'00:'.
Should be easy, right?
So, I tried this - don't worry about the meaning of the WHERE-clause:
R>SELECT TimeTXT, ('00:' + TimeTXT)
FROM INDIVIDUAL_RESULTS
WHERE SeasonCCYY=2008
AND MeetNUM <> 3
AND TimeTXT LIKE '??:??'
Whereupon I received this error message:
-ERROR- TIME cannot be added to TEXT. (2151)
It seems that one of my 2 operands is being interpreted as a TIME type.
But how? And what do I do?
Thanks,
Steve in Memphis
J. Stephen Wills
Program Manager, Research Informatics
Office of the Vice Chancellor for Research
University of Tennessee Health Science Center
62 S. Dunlap, Suite 400
Memphis, TN 38163
Office: 901-448-2389
FAX : 901-448-7133
