Posted by MGFoster on 06/09/06 17:18

anderma8 wrote:
> Can I determine if a value is numberic then output 'text' else output
> 'some other text'?
>
> I'm trying to do this in a select statement.
> Thanks!
>

SELECT CASE WHEN ISNUMERIC(some_column)
THEN 'text'
ELSE 'some other text'
END AS theNumericTest
FROM table_name
.... etc. ...

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Back to original message]