Monday, March 2, 2015

SELECT a String record from a table

May be there are empty space at leading/trailing position.


Please try:



SELECT * FROM #Temp
WHERE LTRIM(RTRIM(Col)) = '/apprecord/'





-Vaibhav Chaudhari


No comments:

Post a Comment