Re: How to generate id number like 'xxx0000', 'xxx0001'?

[Benoit St-Jean]

Here's a hint!

SELECT CONCAT('xxx', LPAD(CONVERT(23, CHAR), 4, '0'));