 |
9.02.2005 Damn, ugly sql :-)  I made an sql query which almost has potential of a daily wtf. I was curious of how many different top level domains that had downloaded umbraco, which should be quite easy - but oh no. T-SQL doesn't provide a LastIndexOf method, so it was time to be creative - and then I stumbled on the "reverse" method, so how about this: select distinct reverse(substring(reverse(email),0, charindex('.', reverse(email)))) 0 Comment(s)...
Comments:
Post a Comment
Older stuff here... |
|
 More banners here...  To the weblog frontpage Email / Contact info umbraco - my company Call me through Skype Blog archive  RSS Feed   commonme.org publicMIND urgent.dk asynkron Hr. Röser Interbreed OpenLife Loudthinking BlogBot.dk  Tim O'Reilly - and his books steve mcconnel joel spolsky steve jobs bruce eckel   |
|
|
|
 |
|
|