Thanks for your participation and advice ,

I think you are right .

Really thanks Chris ,

you saved me hours , and helped me alot ,

big thanks ,

I'll try it now ,

-MHM-

really thanks HowardW

you were absolutely right ,

Now I came up to the point that "Chris Morris" told

the error now is :

Msg 4104, Level 16, State 1, Procedure SearchFlightByCities, Line 41

The...

Thanks , Let me try ...

thanks ,please consider ,

I used fff for Flights table not for @FlightsLook ,

Isn't it a misconception ,

the thing that you say , is it the answer , you...

But the fff is defined 3 lines beneath the

Insert Into ,

Wasn't that correct ?

and about the GO statement , thank you for giving me such hints

Yes , thanks , but after adding them ,

it gives me this error :

Msg 1087, Level 15, State 2, Line 3

Must declare the table variable "@FlightsLook".

It seems that still...

Thanks my friends ,

you helped me a lot during this topic ,

😉

Hello Jeff Moden , thanks for your precise look at my code

What if we have a more complicated text ,

It worked with simple texts ,

but when I copied fore example...

Jeff Moden , again you did great ,

the solution seems to be simple ,

just a quotation ,

thanks ,

--

Dugi , I'll print and look at your code and let you know...

Dugi , Your help is really appreciated ,

the thing that now I asked you is just to know why my code doesn't work ,

please look at here ,

I used a...

I tesed that , It worked ,

but my problem wasn't the nvarchar(Max) ,

the code that you have sent here has some differences from my code ,

you used a TempTable (...

Thanks my friend ,

I'll test it ,

but Is it the best way for two questions above ?

is it a tool for doing that the best way ?

are there any good...

I solved the issue next to my post ,

Jeff Moden is right ,

the problem was because of ther order of what I entered ,

and also one of the variables name...

I solved the issue next to my post ,

I think you are right ,

the problem was because of the N Identifier & quotations ,

excuse me for the delay ,

really thanks