Thanx for a nice answer...

And thanx for a nice blog as well 🙂

Hejsa TreKroner... 🙂

/T

Hi

Allow me to wake this thread up again...

When using this:

select ISNULL(TRY_CONVERT(INT,SUBSTRING('Ejerskifte-45\Behandlet-45',

NULLIF(PATINDEX('%-[0-9]%','Ejerskifte-45\Behandlet-45'),0)

+ 1,LEN('Ejerskifte-45\Behandlet-45')) ),-1)

I get -1 I would like it to be 45

Hey all

You are so right... What a fool I am...

This double-a... something from the past... But still in effect..

Thaxs again to this nice forum...

/T

Hi - thanx for taking your time...

Collation is Danish_Norwegian_CS_AS, but does it matter here ?

I mean... how would you expect AAA, BBB, CCC to be sorted ?

I don't think there...

Nice one... 🙂

I have the assumption that only one hyphen will be in the string, but if the case was

xyz-1-2.3-2

then 2 would be the right answer...

To sharpen...

Hi Tom

I have the assumption that only one hyphen will be in the string, but if the case was

xyz-1-2.3-2

then 2 would be the right answer...

To sharpen a little:...

Someone said: Looks like 123.4 is not an integer, so -1 should be returned.

Yes, that's right

Thanx a lot for all the answers... It's evening here in Copenhagen. I will take...