Searching by First letter?

[whatsthehampton]

Dear all,

I am trying to search my database of families by passing in the first letter as @choice using:-

where (familyname like + @Choice + '%')
order by familyname asc

This works as it should except when the names are Scottish such as McGarva or McIntosh etc.

All help most appreciated,

Cheers,
J

http://www.iSkool.net

 

[ca8msm]

Why doesn't it work with those names? The first letter of the surname is still M in those cases...


------------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions

 

[SQLDenis]

Please provide DDL and Sample data if you want to be helped
Whatever you have should work, are you sure you don't have spaces or other characters in front?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[whatsthehampton]

Dear Both,

My mistake, this code is correct. The problem was that other related data was missing which truncated the records brought back.
Many thanks for your time.
Jon

http://www.iSkool.net