Hi, How do I format a Int field to display 000001 in SELECT INVOICEID FROM TBLINVOICE SF
S SF Jan 9, 2004 #1 Hi, How do I format a Int field to display 000001 in SELECT INVOICEID FROM TBLINVOICE SF
S SFAxess Jan 9, 2004 #2 I believe that is considered text. You could convert to a vchar datatype and then prepend the zeros for displaying purposes.
I believe that is considered text. You could convert to a vchar datatype and then prepend the zeros for displaying purposes.
K Karen Vaudreuil Jan 10, 2004 #3 SELECT RIGHT('000000' + CAST(INVOICEID AS varchar), 6) FROM TBLINVOICE The Cast function is not necessary if InvoiceId is already a character field.
SELECT RIGHT('000000' + CAST(INVOICEID AS varchar), 6) FROM TBLINVOICE The Cast function is not necessary if InvoiceId is already a character field.
