Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
First/Last Name order problems
Cheers for the solution DickieBird, I've actually found another way to do it. Changing Reverse(Left(LTrim(reverse(sName)), (PATINDEX('% %', LTrim(reverse(sName))) - 1))) To LTrim(Reverse(Left(LTrim(reverse(sName)), PATINDEX('% %', LTrim(reverse(sName)))))) Has the desired effect. Thanks... -
First/Last Name order problems
I have a database (which I can't alter!) where people's first and last names are stored in a single column. I've written an ordey by statement (MSSQL 7) to order my output by the last name as below: SELECT sName FROM tblUsers ORDER BY Reverse(Left(LTrim(reverse(sName)), (PATINDEX('% %'... -
Problem with format of decimals between 0 and 1
Hello All, I'm having problems with the output of queries that return the values from a decimal column in one of my tables. The values return as desired unless they are between 1 and 0. In this case the zero is truncated from before the decimal point. E.g Value Returned as 1.56 1.56 7...- chazbadd
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
