Hi Luis,

Thanks for your reply, and I must say: you can knock me over with a feather.

Sorry for asking this question. I tried to run run the code again and...

Hi Ten Centuries

Thanks for your reply,

As far as I can see your code works just the other way around from what I am looking for.

In my example I have a...

Hi Bill

Did you do the select on a different table (named tbPersons) with values in field prsLastName ?

If in your 1st tryout the names in the @Lastname table match the...

Hi Louis

Good to hear from you again!

What I am trying to do is, in a database for speedskating, get all records that have e.g. the word 'World', or 'Nederlands' in...

Sounds good,

36 will do!

Thanks again

Hein

Hi Chris,

Thank you for your reply.

It works like a charm 🙂

1 question if permitted: is there a limit to the number of replace functions you can use "in 1...

Hi Wayne

Thank you for your valueable addition .

I've looked into the stairway, and there's much to learn 🙂

It will take some time but that's OK

The Redgate eBook I've taken a...

I will dive into Powershell

In fact I have looked on Youtube, but these films take longer than I had time today.

The learning never ends 😀

Hein

Luis

I can't say how happy I am, it works!! 😀

Muchas Gracias, soy?/estoy? muy contento

In first instance I had "overcorrected" the code, changing 'servername' with 'MSSQLSERVER' which didn't work.

After I...

Hi Luis

Good that you're online and thanks for your response.

I think there's some movement in our quest.

I have ran your code (after adapting it to my situation, like servername, and...

Luis,

Sorry, I am afraid this is ground too unfamiliair for me. Alas.

I have spent the better part of my afternoon trying to get things to work, but have failed so...

Hi Luis

Thanks for your reply.

I have not yet heard of the bcp - utility but am searching for information.

Your suggestion looks very promising, but has as far as I can...

Once again thank you,

I will change the code the way you suggested.

Thanks for putting me on the right track.

I will set this thread to solved

Hein

Hallo Eirikur,

Thanks for your reply! I was afraid it would go by unnoticed.

I have used your code and it works flawlessy!

I am fairly new to SQL Server but I...

Luis, Sorry for not replying to your thread yesterday.

Timedifferences between the Netherlands and Mexico ...

Anyway: the results of your code looks to be exactly what I am looking for.

I hope...