April 2008 Q&A Column

Are hyperlinks supported in my ESEND e-mail messages?
Yes, if the message type is *HTML. Here are some formatting tips:

• E-mail links: Use mailto:myname@mydomain.com or just myname@mydomain.com.
• Web site links: Use http://www.helpsystems.com or just www.helpsystems.com.
• Document links: Enter the complete HTML reference <A href="http://www.helpsystems.com/intel/video.html">a SEQUEL movie page</A>. This will display as a SEQUEL movie page in your e-mail.

I am trying to move a Microsoft Access project to SEQUEL ViewPoint and I am stuck on one formula. In Access, I use this formula to add a trailing 00001 to a trimmed field: Left([eqmfsn],4) & "00001" How would I do this in Viewpoint?
Here's a good way to handle this in Viewpoint:

SELECT DECIMAL(CAT(SST(CHAR(cusno),1,6), CHAR('00001')),15,2) name(calc1), cusno*100000+1 LEN(15,2) name(calc2)

FROM sequelex/custmast

Just replace the name variables with your own file names.