Thank you.

the back ground is I am using regexp in sql (not really perl this time)

I tried the following:

REGEXP_SUBSTR({total},'^*', 1, 1) where total is the input string

I result I am getting is its not recongizing the empty (or null) columns.