Hiya,

I'm back with another question.

I have a view of a table which contains users. the SQL is:

Code:
CREATE VIEW dbo.vwTravellers
AS
SELECT     TravellerID AS ID, LTRIM(RTRIM(LastName)) + ', ' + LTRIM(RTRIM(FirstName)) + ' - DOB:' + LEFT(RTRIM(DOB), 11) AS Value
FROM         dbo.tblTravellers
I would like to be able to sort the view by LastName, Firstname, but it doesnt allow a SORT BY in the view. Does anyone know of a cheeky little trick I could use to get around this?

Cheers
Guy

I wish I'd listened in that SQl Server training course I attended