Substring does not work in Filter using custom

[SithDavid]

Using the Filter Tool 

Adding a custom Filter

Substring([PLAN1],1,2) = "SL"

But does not return any Trues

Example of the string in [PLAN1]

SL_BASECOAT

FB_1M2461RLB

What am I doing wrong?

[fmvizcaino · Accepted solution]

Hi @SithDavid ,

To get information from the first 2 characters with this function, you need to use Substring([PLAN1],0,2)

You could also use a left([PLAN1],2) function and have the same result.

Let me know if that works for you.

Best,

Fernando V.

[SithDavid]

Thank you.  That Worked