Storing the data that way contradicts the first normal form, which is
atomicity, or as I summarise it 'store one piece of data in one field'.
Normalising your data to the nth degrees can cause performance losses,
however it is generally a good policy. In your case you have had to do some
tricky SQL to deal with this problem.

regards
David Cameron
nOw.b2b
dcameron@i...

-----Original Message-----
From: jerry diegel [mailto:jerry.diegel@h...]
Sent: Thursday, 11 October 2001 5:20 AM
To: sql language
Subject: [sql_language] Order By


In my table I have a record with a field called username that is stored in 
a "Domain\username" format.  What I would like to do is put together a 
query that would sort the records by the username, ignoring the domain.  I 
want to sort by everything after the "\", any suggestions?

Thanks,

Jerry

_=_NextPart_001_01C151E6.A7D82D98--