SQL Server Forums - How to order a column logic

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

How to order a column logic

New Topic

Reply to Topic

Printer Friendly

Author

Topic

insanepaul
Posting Yak Master

172 Posts

Posted - 04/12/2012 : 10:58:26

These are strings in the table under column xmlTransaction and they can be in any order:

<Person update >
<Person insert >
<CPAdress update >
<CPAdress insert >
<Person update >
<Person insert >
<CPAdress update >
<CPAdress insert >

I always need all the <Person insert > to be at the top and
It doesn't matter about the others.

If I order by xmlTransaction I get CPAdress before Person
If I order by xmlTransaction desc I get Person update

I could just get the Person Inserts then the person updates then CPAaddress but thats a bit of an effort and I don't know how to escape the = and quote marks as the full string is:
<Person ActionType="Insert"

Edited by - insanepaul on 04/12/2012 11:25:52

russell
Pyro-ma-ni-yak

USA
4965 Posts

Posted - 04/12/2012 : 11:26:29