how to specify the column name

[gobiparthi]

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.

[Jack Vamvas]

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(v archar(4),@numb er)

--
----
Jack Vamvas
_______________ _______________ _____
Receive free SQL tips - www.ciquery.com/sqlserver.htm
_______________ _______________ _____
"gobiparthi " <go*******@gmai l.com> wrote in message
news:11******** **************@ g10g2000cwb.goo glegroups.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.

[DickChristoph]

Hi Gobi

Not sure if you meant how to define the table or query it But here is how
you would define it.

Create table accountnums(
row_id int not null identity(1,1) Primary Key,
acc_no varchar(6))

alter table accountnums add CONSTRAINT CK_acc_no CHECK (acc_no LIKE
'[A-Z][A-Z][0-9][0-9][0-9][0-9]')

insert accountnums(acc _no) values('aa1234' ) --OK
insert accountnums(acc _no) values('AA1234' ) -ok
insert accountnums(acc _no) values('A11234' ) --Generates error.
--
-Dick Christoph

"gobiparthi " <go*******@gmai l.com> wrote in message
news:11******** **************@ g10g2000cwb.goo glegroups.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.

[Madhivanan]

http://vyaskn.tripod.com/object_naming.htm

Madhivanan
gobiparthi wrote:

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.