RE: NEED YOUR OPINION

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 25 Jun 2002 08:53:28 -0800
Message-ID: <F001.00486F90.20020625085328@fatcity.com>

where
to_number(replace(msc_service_code,'ABCDEFGHIJKLMNOPQRSTUVWXYZqazwsxedcrfvtg byhnujmikolp')) between 7 and 30 ...

Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Tuesday, June 25, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L

LYNDA, If you look at my table staructure service_code in varchar2(30)and the data in this column can be a number or a number start with a charachter(A-Z)like A1200,B6500,Z9098 etc,in first subquery I want to select all those service_code wich start with (0-9) then in WHERE Clause I use TO_NUMBER becaz I know in subqury It returns all the numeric values: E.G
select count(*)
> from (select MSC_SERVICE_CODE,MSC_MTF_SERVICE_ID

>    	  from MTF_SERVICE_CODE_MSC 
>           where 
>        	  substr(MSC_SERVICE_CODE, 1, 1) in  
> ('9','8','7','6','5','4','3','2','1','0')) a  ----->>> reurn all service
code start with 0-9


> 		 	where

>        		 to_number(a.MSC_SERVICE_CODE) between 7 and 30

--->> Here a.MSC_SERVICE_CODE convert it to TO_NUMBER .

Thanks allot

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



text/plain attachment: ESPN_Disclaimer.txt

Received on Tue Jun 25 2002 - 11:53:28 CDT