Trim a field in In-DB

[AJ-CH]

Hello Friends, 

I am looking for solution to Trim the first 2 characters of a V_String Field in In-Database.

Thanks for help in Advance!!

[jdunkerley79]

Depends on the database server you are connected to unfortunately.

Oracle uses SubStr([Field],3) and SQL Server uses SubString([Field],3, LEN([Field])-2)

See http://www.sqlines.com/oracle/functions/substr

[AJ-CH]

My Bad, I didn't explain my question correctly,. I am looking for solution to get only first 2 characters from a v_string field. 

[MarqueeCrew · Accepted solution]

left(field,2) should likely work in your SQL.

Cheers,

Mark