gernating a key?

[DOGWATCH]

I have unique company name for e.g.
company = "NEW YORK MED CTR" from that I would like
make a function to encode it into some kind of alpha numeric code that would be the equivalent.

I've considered maybe doing some kind of string to hex function, but haven't found much in terms of T-SQL solutions all all example ive found have been in java or .net

 

[SQLDenis]

Do you want arbinary?, take a look at this

[COLOR=blue]select[/color] [COLOR=#FF00FF]convert[/color]([COLOR=blue]varbinary[/color](100),[COLOR=red]'NEW YORK MED CTR'[/color])
[COLOR=blue]select[/color] [COLOR=#FF00FF]convert[/color]([COLOR=blue]varchar[/color](100),0x4E455720594F524B204D454420435452)

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

 

[gmmastros]

Maybe a simple conversion to binary?

[COLOR=blue]Select[/color] [COLOR=#FF00FF]Convert[/color]([COLOR=blue]Binary[/color], [COLOR=red]'NEW YORK MED CTR'[/color])

[COLOR=blue]Select[/color] [COLOR=#FF00FF]Convert[/color]([COLOR=blue]VarChar[/color](1000), 0x4E455720594F524B204D4544204354520000000000000000000000000000)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

[ROFL]

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

 

[gmmastros]

ha ha ha.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

BTW you should use varbinary not binary (notice the zeroooooos) and binary will only work until 30 (I believe) chars

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