Select only part of field in query

[CraigBest]

Stupid question, I used to know this, but I can't find where I wrote it down...

I'm constructing a query where I need to do a select on a part of a field (first three characters out of twelve represent a department code). I need to define that subset of a field as a field in the recordset I'm building.

In VB I could use a MID statement:

mid(VarName, 1,3)

To define that part of the field. I know the PL-SQL syntax is similar, but I can't find the definition.

Can someone throw me a quick bone and help a harried soul struggling to meet a deadline?

Thanks

Craig in NJ

 

[karluk]

Try substr(VarName,1,3)

 

[CraigBest]

Thanks! That's exactly what I was looking for.

Craig in NJ