#DateForumTypeThreadPost
230 Jan 2015 @ 11:41 PSTDatabaseReplyREGEXP_INSPR works on litteral data, but not in SELECTSeems the problem was a hidden Control Characters in the VARCHAR(50).  Here is the modified version for any interested parties.  I'm guessing there is probably an easier way to deal w...
128 Jan 2015 @ 02:54 PSTDatabaseTopicREGEXP_INSPR works on litteral data, but not in SELECTTrying to use REGEXP_INSPR to identify if a VARCHAR(50) column contains data that can be converted to Decimal(8,2) and if so convert it.  Below is my SELECT: SELECT    &nbs...