Can i use 'LIKE , % etc...' in DECODE.
Can i create a query as follows?
1. SELECT item_code, decode(item_code,%a%, 'Contains a', 'not contain a')
2. SELECT item_code, decode(item_code, BETWEEN 0 AND 9, 'NUMERIC', 'NOT
NUMERIC')
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2557
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
