Thanks John Ill get our developers to look in to it and see if they can fathom anything out!!

John, I get the following result:

Lukac

I.e. missing the accent on the c but not having the & # business!

The collation of the db is set to:

SQL_Latin1_General_CP1_CI_AS

The client machine in this...

I thought it might be confusing looking at it...

See the 1.jpg - that is the exact data being entered, and the exact form it's entered in.

If I basically...

I completely had not thought of doing it like that GSquared, it's a much tidier and simpler way of doing it that works just fine! - I tend to find...

I didn't know that, but it does make a lot of sense with something I was just doing - so thanks...

I think that may have to be the case, there are many inconsistencies with the naming conventions - van for example - sometimes its lower case, sometimes its capitalized, usually...

Hmm, I kinda see what your getting at, however, I've tinkered and came up with something that works, all be it not overly elegant!

declare @string varchar(50)

select @string = 'Mike'

IF

NOT

(ASCII(substring(@string,1,1))...

I'm now trying to see how I could save this and use it as a template when creating a new query from within Management studio - i.e. create new query...

SNAP! hehe

Hmm, I'm not too sure what you mean there, however, a colleague advised me that I could get round it by adding an ELSE BEGIN END after...

Hey Michael,

Close, its more something for me personally actually! - With identical databases but just different servers its oh to easy to run a query on the local server...

I'd discovered that if I remove the space from the patindex string it works.

However, I'm not fully aware of the consequences of removing this space character from that string -...

The purpose of this propercase function is basically to tidy names in our CRM system, on the whole it works quite well, however, I've tracked down a couple of issues:

Original...

The first time the original string...

'%[-( '']%'

Was replaced by

'%[-( ''].%'

And it did not work, it didn't capitalize anything!

So, I changed it to

'%[-( ''.]%'

As per your instructions and it worked

However, on...

Thanks Ryan, that worked a treat!

One thing which I didn't think would matter is the position of the '.' - I put it in the same place in each of...