Home » SQL & PL/SQL » SQL & PL/SQL » Search on first 3 characters of data
Search on first 3 characters of data [message #208212] Fri, 08 December 2006 11:26 Go to next message
blakhama
Messages: 10
Registered: August 2006
Junior Member
I am looking to do a search on only the first 3 characters of data in a column. FOr example, I am looking to do a search in COLUMN2 on the first 3 characters of the data "227NUTZ", "227SAC" so only my result will return the unique 227 and drop everything following the first 3 characters.

Thanx!
Re: Search on first 3 characters of data [message #208223 is a reply to message #208212] Fri, 08 December 2006 12:26 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
substr
Previous Topic: Checking date lag and merging several records into one
Next Topic: SQL
Goto Forum:
  


Current Time: Sat Dec 10 07:06:32 CST 2016

Total time taken to generate the page: 0.04484 seconds