Bad character in format or data

Database

Bad character in format or data

Hi I am a newbie in TD. I need your help in identifying the bad character on my table. I'm only expecting negative & positive numbers as my result.

column_abc CHAR(19) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT NULL ,

Thank you in advance.

4 REPLIES

Re: Bad character in format or data

Is there away to find a string or special character in this column_abc?

Senior Apprentice

Re: Bad character in format or data

You could use a REGEXP_SIMILAR, but the easiest way is TO_NUMBER(column_abc), which simply returns NULL if it can't be converted to a numeric value.

Re: Bad character in format or data

Thank you so much Dieter, you solved my problem.

Enthusiast

Re: Bad character in format or data

REGEXP_SIMILAR('2A','^[0-9+]$',i') returns 0

REGEXP_SIMILAR('2121121','^[0-9+]$',i') returns 1

Works in >= TD 14