Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

smart first name matching in TSQL Expand / Collapse
Author
Message
Posted Wednesday, June 19, 2013 9:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 9:22 AM
Points: 55, Visits: 559
Yes, I think it will be 2 options: use "smart" first name matching or by last name only
Post #1465248
Posted Wednesday, June 19, 2013 9:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,116, Visits: 6,438
crmitchell (6/19/2013)

...the Scottish variant is Iain - both are legal names.



My apologies


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1465251
Posted Wednesday, June 19, 2013 9:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,116, Visits: 6,438
onixsoft (6/19/2013)
Yes, I think it will be 2 options: use "smart" first name matching or by last name only


Even last name won't be accurate. My surname is sometimes spelled in three words, sometimes two, or even in one word. And then there may be a "C" in it or not.


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1465264
Posted Wednesday, June 19, 2013 10:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 2:30 AM
Points: 214, Visits: 855
Jan Van der Eecken (6/19/2013)


Even last name won't be accurate. My surname is sometimes spelled in three words, sometimes two, or even in one word. And then there may be a "C" in it or not.


to be honest I always thought the v was lowercase :) but I try to always assume the person knows how their own name should be spelt better than me.
The same issue would also arise with the German von and the French Le or De and in those cases they may be shortened to l' or d'
Then these's Mac which may also be Mc - with the c either normal size or presented as a superscript character.
And good luck dealing with the various accented characters.
Post #1465273
Posted Wednesday, June 19, 2013 10:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,116, Visits: 6,438
Hehe,

I'm born Flemish, in other words Belgian. There the lower case 'v' in 'Van' means you've got some royal blood somewhere, maybe generations ago. So I'm obviously not in that league, I just come from the oak tree. In the Netherlands they don't make that distinction. So they are all kings


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1465279
Posted Wednesday, June 19, 2013 12:26 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 19, 2014 12:46 PM
Points: 1,051, Visits: 2,554
Jan Van der Eecken (6/19/2013)
Hehe,

I'm born Flemish, in other words Belgian. There the lower case 'v' in 'Van' means you've got some royal blood somewhere, maybe generations ago. So I'm obviously not in that league, I just come from the oak tree. In the Netherlands they don't make that distinction. So they are all kings


Same was true in Germany and Austria before the abolition of the nobility in 1919. The word "von" roughly translates to "of" or "from". Von with a capital "V" was a nobiliary particle - it indicated that the bearer was of the nobility. When the nobility was abolished, many German nobles just made "von" part of their names. In Austria, even the use of "Von" or "von" in a name was abolished, so former Austrian nobles just dropped it from their names.


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1465326
Posted Wednesday, June 19, 2013 1:13 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,116, Visits: 6,438
Wolf, don't say you are Austrian, or are you? Passport-wise I'm too. Spent my teens in Vienna and a few more years after that.


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1465350
Posted Wednesday, June 19, 2013 2:08 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 19, 2014 12:46 PM
Points: 1,051, Visits: 2,554
Jan Van der Eecken (6/19/2013)
Wolf, don't say you are Austrian, or are you? Passport-wise I'm too. Spent my teens in Vienna and a few more years after that.


No, my family's from Hesse, but we left there in the 1770s - the time frame may give you a hint as to the destination and how it worked out for Jacob Wolfskehl, my ancestor (pretty well, in the end, after a pretty rocky start).


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1465374
Posted Wednesday, June 19, 2013 2:40 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 2,787, Visits: 6,098
I never knew you were descended from mercenaries.


__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #1465388
Posted Wednesday, June 19, 2013 2:44 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:03 AM
Points: 2,116, Visits: 6,438
So I got the idea right. Anyhow, that's beside the OP's question


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1465389
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse