Help with Substr script

[Chilly]

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

[samsrikvsk]

Instead of trying the substr function u may consider using the instr function on the part key to match with fsc field from the table.It should help U pretty well in getting the results