Friday, August 2, 2013

Netezza regexp_like. Regex to find integers only

regex is very handy and to be able to use it as part of a sql is just plain awesome I think.

I needed to find all records that only has integers in that field and this is how I did it:

select *
from TABLENAME
where regexp_like(INPUTCOLUMNNAME ,'^\d+$');


1 comment:

  1. NETEZZA Online Training
    Call Us-91-900-044-4287 21st Century Software Solutions Online Training
    IBM Netezza Overview
    Netezza Architecture
    Connecting to Netezza
    Databases
    Tables
    Database Objects
    Data Distribution
    Loading and Unloading Tables
    Statistics
    Zone Maps
    Clustered Base Tables
    Materialized Views
    http://www.21cssindia.com/courses/netezza-developer-online-training-21.html

    ReplyDelete