Truncate Field

[lkeller]

I am trying to truncate a 9+ account number to only display the last 4 digits. I have tried a few different ways of doing it, with the ASP Trim command, and using the Right function from the SQL SELECT.This is the sql select code:

strSQL = "SELECT * from AccInfo where AccNum=" & Prep4SQL(frmAccNum,"STRING")

and this is the email where I'm putting the Account Number:

strEmailBody = strEmailBody & vbcrlf & _"The last 4 digits of your account number are " & frmAccNum & vbcrlf

This currently works and displays the full account number in the email.

[justsomeguy]

http://www.w3schools.com/Vbscript/func_right.asp

[lkeller]

http://www.w3schools.com/Vbscript/func_right.asp

Thank you, I should of found that myself.