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!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ripperfuel
  • Content: Threads
  • Order by date
  1. ripperfuel

    substring function on numeric and charaster values

    Case 1: select substring ('12345678', 3, 3); gives 345 as result, which is fine. Case 2: select substring (12345678, 3, 3); gives 12 as result, and select substring(12345678 from 7 for 2); gives 45 as result. I realize I used number in case 2. Can you explain why I am getting '12' and '45' for...

Part and Inventory Search

Back
Top