Hello

I looking for the solution for extracting the text part and numeric part seprately. The exact requirement is like this.

To extract first part of string till the first numeric value that is preceded by a single space.
Examples:
‘Dorpsstraat 48’ = ‘Dorpsstraat’
‘3e dwarsstraat 23’ = ‘3e dwarsstraat’
‘Singel 6-III’ = ‘Singel’
‘Dorpsstraat dwarsstraat 23’ = ‘Dorpsstraat dwarsstraat’

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

with thanks
Fraijo

You kinda double posted... go look at your more recent post and find the solution I posted. Then, do the opposite...

--Jeff Moden

Hi.. Jeff..

I Got the answer.. Thank you very much for helping me..

--Fraijo

Declare @str varchar(100)
Declare @strnew varchar(100)
declare @i as int
declare @l as int
set @str ='3 Dorpsstraat 6-III'
set @strnew =''
set @i= len(@str)
set @l= 1
while @l<=@i
 begin
 if (substring(@str,@l,1)=' ' AND isnumeric(substring(@str,@l+1,1))=1)
  begin
    print @strnew
  end
 else
  begin
   set @strnew = @strnew + substring(@str,@l,1)

  end

 set @l = @l +1
 end

As a matter of courtesy to the other folks on this forum, would you mind posting your solution? Thanks...

--Jeff Moden