Archives of the TeradataForum
Message Posted: Thu, 24 Apr 2008 @ 16:56:40 GMT
I need to write an SQL on a text field. Basically the text field could contain any number of characters. I need to extract only the numeric. The field is VARCHAR(2000). Obviously a huge CASE statement for this large of a field would be tedious and probably resource intensive.
Has anyone done anything like this before?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|