Syed,

Just realised I missed a closing bracket, one after the +1, should read:

select RIGHT(mytext, Len(mytext) - patindex('%[^0]%', mytext)+1) from mytable

Obviously I should have said replace "mytext" with you column name,...

Hi Syed,

I had a similar problem when bringing together account information from three different sources and combining them into one report, without leading zeros - don't you love it when...

noggin,

I found this MSDN article:

http://msdn2.microsoft.com/en-us/library/ms189566(SQL.90).aspx

UNSAFE

Hi Lester,

You don't neccessarily have post the whole sproc just the important bits..

But having said that and re-read you previous comments. It does sound as though one the input variables...

Hi Lester,

Yes I realise that it didn't solve your sproc problem but it's best practice, and when you start using cast with a varchar bigger than 30 characters it would...

Hi Lester,

While you are correct in saying that the size part of varchar is optional in teh Cast, you should really specify the size as it will default to 30...

Mick,

RETURN is what you are looking for.

BOL shows an exmaple in a stored procedure.

Cheers,

Rodney.

This might have something to do with Financial Year Starts. If July 1st is the start of the fiscal year then July would come before December, but January would come...

Hi Guys,

I have been getting used to the badly written questions. So I thought Ah Yes the answer is 3, because of the WITH TIES, but then I saw answer...