How to Extract first five character from any Column??

[jsingh71]

Hi,

I have one column (Subject) value is (W0696 RE: RE: Employee GID 1000211087).

Now I want to extract only (W0696). For using which function I got this???

[Nicole-Smith · Accepted solution]

left(Subject, 5)

or

subfield(Subject, ' ', 1)