>Brian,
>
>The function that you are looking for is DTOC()
>
>>There must be a fairly simple way to to do this, but I'm missing something. How do you convert the DATETIME() value to a character expression? I'm trying to make an index that sorts on a part number (alphanumeric) and then the DATETIME(). I'm building a transaction log that records when a part's information was modified.
>>
>>Thanks for any help,
>>- Brian

I didn't know that DTOC() would do that - I know about TTOC().