auto gerenated char+ numeric customer id

[veer123]

I need a query to generate the client id automatically with in my client table.
Currently i can generate it in this format 1001,1002,1003. .. . but I need
another char value before the numeric value..
ex: CJ1001, CJ1002

[Dlovan]

you can use varchar type for the operation