String manipulations HELP!!!!

I have 2 sql questions dealing with string manipulations

1. I have a bunch of columns in the database that I need to check if they are null.

all of the columns end with _ID (ie account_id,session_id,feature_id) I also have columns in the database like the following (accountid, sessionid,featureid) i need to check the columns with the _id for null's. I have a dynamic sql procedure that will do this if I can identify the columns

select table_name,column_name
from dba_tab_columns
where table_name like '%DW2%STG%'
AND column_name LIKE '%_ID%'

the above query will not work because of the "_" Underscore. How can I look for these columns.

2)I have a column which contains a http url string http://ad.doubleclick.net/ad/main.cdnow/RP/SHARE/sound_popup.html;sz=250x250;gid=;fid=85475;artid=;itmid=;formatid=;promoid=;kword=;collid=;fmtag=;adloc=top_center;lang=ENG;ord=535276841_0?

In this string i am looking FID=85475 ( or what ever number is after fid) this string can be anywhere in this string.

PLEASE HELP Dan White
programmer/analyst Received on Fri Jan 19 2001 - 15:17:02 CST