Don't enclose the variable @OrderBy in quotes. Because it was defined as type varchar, the db already knows it's a string. |------------------------+------------------------------------------------| |Eric A. Laney |You will be where you most desire to be in a | |Systems Engineer |short while. | |LAN Optimization Team | | |Verizon Data Services | | |Voice: 813.978.4404 | Today's Fortune| |Pager: 888.985.8519 | | |------------------------+------------------------------------------------|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
