Hi,

this is constant of the 3 digit from right then

try this

declare @result varchar(15)

set @result = '20090801001'

select right(@result,3)

Hi Jeff,

I think, need the statement for the comma delimited row to the column,

Colin already use the COALESCE statement, actually may Colin need the better one then COALESCE!!!

Hi,

try this

create table #temp1

(

slno int,

inv_no varchar(10),

inv_dt datetime,

payment_term1 varchar(10)

)

insert into #temp1

select 1,'INV01','2009-01-01','30'

union all

select 2,'INV02','2009-01-02','30'

union all

select 3,'INV03','2009-01-03','30'

union all

select 4,'INV04','2009-01-04','30'

union all

select 5,'INV05','2009-01-05','30'

select *,(inv_dt+(cast(payment_term1 as int)))real_dt from #temp1

Hi,

try this

create table #temp1

(

id int,

reg_no int,

leave int,

typeid int,

allowed varchar(50),

remarks varchar(50)

)

insert into #temp1

select 1906, 10800720, 1, 2,'Night stay', 'with local guardian is not'

union all

select 1909, 10800720, 1, 2,'Night stay', 'with...

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

Hi,

Zeal person only having these type of dreams, you note it down your entire dream in the record its help one day defiantly.

Hi,

use the random values

declare @i int

select @i = (RAND()*100)

select CAST(@i AS bigint),@i