I am new to creating scripts and can do basic select and update scripting. I am trying to extract information from an Oracle database. The table is CAT1 and the fields are PART and FSC. I want to extract all lines in the PART field that match the FSC. The part field has a max of 20 characters and the FSC has a exact lenght of 4. I used a script to view the first 4 characters of the PART field
SELECT SUBSTR(PART, 1, 4)AS PART
FROM CAT1
But I want to extract the full PART field that match the FSC. An example would be
PART 5345010577654 with the FSC 5345
Maybe I shouldn't be using substr for this and I am lost :-)
Any help would be greatly appreciated.
Chilly