Hi,
I have a problem and I don't know if there is a solution, but I hope so:
I have a VARCHAR column with alphanumeric-, numeric- and date-values.
Depending on the value of another column I know the type of the value (alphanumeric-, numeric- or date-value).
When the type is a numeric value I need to cast it to a number, so it can be compared to another number.
But if it is not a numeric value that row has to be skipped even though it can be in the resultset.It works fine when
there are only numeric values in the resultset. So I need to differentiate between the numeric and other values.
Is this possible?
Greetings,
Sander.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
