Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SUBSTR/INSTR Help.
Thanks LKBrwnDBA. How can reverse that to just show the supplier number, i.e. everything before the star? Thanks- markfcuk
- Post #7
- Forum: Oracle: All versions
-
SUBSTR/INSTR Help.
fantastic!! that works perfectly. While I'm here can I ask for help with formatting a number? stock_value is returned as 7834.3847847987 Can i format this to two decimal place or as a money field £7,834.38? I tried this but I get an error. SELECT substr(rec_supplier...- markfcuk
- Post #6
- Forum: Oracle: All versions
-
SUBSTR/INSTR Help.
Oops sorry i should have checked my post first!! I only want to keep the company name (which could contain numbers i.e. 365 electrical) So I want everything after the 1st * Thanks for your quick reply.- markfcuk
- Post #3
- Forum: Oracle: All versions
-
SUBSTR/INSTR Help.
Hi There, I was wondering if someone could help me with my transition from MSSQL to Oracle. I have a field name call rec_supplier which contains supplier names with supplier account numbers seperated by a * like this REC_SUPPLIER ============ 2321*Supplier 1 333*Supplier 2 38584*Supplier 3 I...- markfcuk
- Thread
- Replies: 9
- Forum: Oracle: All versions
