Jump to content

Truncate Field


Recommended Posts

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...