Thanks Chris, I have implemented that thing....

But I am not clear why you posted that...

ChrisM@Work (3/19/2013)

---

kapil_kk (3/19/2013)

---

i have a column in my table which has values like 'value Based', 'value Discount', 'Percentage Discount'.

I want to extract first letter from these words as 'VB', 'VD',...

Prasad.N (3/19/2013)

---

hi

find below code

declare @retval varchar(100)

DECLARE @Str VARCHAR(100);

set @Str='Nyal Pra Raj'

SET @str=RTRIM(LTRIM(@str));

SET @retval=LEFT(@str,1);

WHILE CHARINDEX(' ',@str,1)>0 BEGIN

...

Hey Chris I am not getting what you want to point out by this :w00t:

ChrisM@Work (3/18/2013)

---

kapil_kk (3/18/2013)

---

;with cte as

((select min(VoucherNo) VoucherNo, TransactionID from GV_Voucher

group by TransactionID

--order by VoucherNo asc

)

union all

select max(VoucherNo)VoucherNo, TransactionID from GV_Voucher

group by TransactionID

--order by VoucherNo desc

)

select * from cte

Thsi...

Eugene Elutin (3/18/2013)

---

In the same...

can you plz explain me how Min, MAX is working with alphanumeric values like 'VB00001'

;with cte as

((select min(VoucherNo) VoucherNo, TransactionID from GV_Voucher

group by TransactionID

--order by VoucherNo asc

)

union all

select max(VoucherNo)VoucherNo, TransactionID from GV_Voucher

group by TransactionID

--order by VoucherNo desc

)

select * from cte

Thsi will also...

very good question to start of the week.. 😛

I have solved it..... forget to initialize the IsBookelet variable value ;-):w00t:

This is the table structure if anyone requires:

REATE TABLE [dbo].[GV_Voucher](

[VoucherId] [int] IDENTITY(1,1) NOT NULL,

[VoucherTypeId] [int] NOT NULL,

[VoucherNo] [varchar](20) NOT NULL,

[Denomination] [int] NOT NULL,

[BookletId] [int] NULL,

[ExpiryDate] [date] NULL,

[CreatedDate] [datetime] NULL,

[ModifyDate] [datetime]...

Danny Ocean (3/15/2013)

---

kapil_kk (3/15/2013)

---

Danny Ocean (3/15/2013)

---

Really a nice and good question.

one more thing apart from this question. if you set ARITHABORT OFF and then execute below code, it will give...

Danny Ocean (3/15/2013)

---

Really a nice and good question.

one more thing apart from this question. if you set ARITHABORT OFF and then execute below code, it will give output as "*"...

Danny Ocean (3/15/2013)

---

Really a nice and good question.

one more thing apart from this question. if you set ARITHABORT OFF and then execute below code, it will give output as "*"...

demonfox (3/14/2013)

---

cheeky ...

didn't occur a doubt on the 0 😛

though I had a doubt over

select isnull ( convert (char(3),1.0/9) ,'*')

-- or

select isnull ( convert (char(3),1/9.0) ,'*')

and it clears out...