We executed a dynamic SQL statement (not a complex one) and we have an order by clause at the end of it. This statement does a join of 2 tables. The strange thing is that the order by seem like it doesn't work. The results are not in sequential order.
If we were to do a straight select on just one table (for which we are doing the order by on) everything is ok.

Has anyone experienced this before?

never

tip: it might be a good idea to show the query that is misbehaving

Thanks. This is my first post on the forum. I guess it shows?

We figured it out. We forgot to put some \'s at the end of last few rows to indicate that the SQL continues on the next line. So it never got to the sort option. Ah... it's Friday.