Hello

I need your help to solve this critieria. I'm looking for a solution for extract the value from a field. The exact criteria is like this..

‘Dorpsstraat 48’ = ‘48’
‘3e dwarsstraat 23’ = ‘23’
‘Singel 6-III’ = ‘6-III’
‘Dorpsstraat Singel 70’ = ‘70’

how can i do it.. can pls help me? I'm very much thankful to you if you do so..

with thanks
Fraijo

SELECT RIGHT(yourcolname,CHARINDEX(' ',REVERSE(yourcolname))-1)
  FROM yourtable

--Jeff Moden

Hi Jeff Moden

Its statrted working.. Thank you a lot..

with regards
Fraijo

You are welcome... thank you for the feedback.

--Jeff Moden