I need to generate the ClientID

<i><b>Originally posted by : Thor (tct@clara.net)</b></i><br />Hi<br />I need a script that will generate a code from 2 * fields.<br /><br />Company + AutoID<br /><br />Company is text<br />AutoID is autonumber<br /><br />This is the current code which is fine <br /><br /> ClientID = Left(CompanyName, 4) & Format(AutoID, "000")<br /><br />However in ASP web (drumbeat) it does not allow 'format'.<br />I need to generate the ClientID using VBScript .<br /><br />Can you help<br />Thanks<br /><br />

<i><b>Originally posted by : Leslie</b></i><br />In VBScript, there is no "format" function. However, there are FormatNumber, FormatCurrency, FormatDateTime and FormatPercent functions. Try checking out the online documentation at MS for details on syntax, etc at:<br /><br />http://msdn.microsoft.com/scripting/<br /><br />Respectfully,<br />Leslie<br /><br />------------<br />Thor at 5/19/2000 9:01:42 AM<br /><br />Hi<br />I need a script that will generate a code from 2 * fields.<br /><br />Company + AutoID<br /><br />Company is text<br />AutoID is autonumber<br /><br />This is the current code which is fine <br /><br /> ClientID = Left(CompanyName, 4) & Format(AutoID, "000")<br /><br />However in ASP web (drumbeat) it does not allow 'format'.<br />I need to generate the ClientID using VBScript .<br /><br />Can you help<br />Thanks<br /><br />