Posted by Jack Vamvas on 06/13/06 16:56

what is the naming procedure i.e will you know what the letters and numbers
will be .
If you mean dynamically create the value then
DECLARE @number INT
SET @number = mynumber
'aa_'+convert(varchar(4),@number)

--
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________


"gobiparthi" <gobi.sdce@gmail.com> wrote in message
news:1150186162.136272.244460@g10g2000cwb.googlegroups.com...
> Dear friends,
>
> If i want to specify the column name as "acc_no" then it
> total size is 6 it must get the first two letters as alphapets and the
> remaining 4 as numbers for this how to write the query?. Please reply.
>
> By,
> Gobi S.
>

[Back to original message]