Click here to Skip to main content
15,896,269 members

Comments by elecsvz (Top 5 by date)

elecsvz 17-Jan-15 13:01pm View    
thank you very much koorevs for answer me, but that line is fine as it was, work fine. check the capture: http://i1078.photobucket.com/albums/w482/Eleazar_Celis/Captura_zps58ed6ba3.png
elecsvz 17-Jan-15 12:58pm View    
:)
elecsvz 17-Jan-15 12:57pm View    
yes, with what little I know of transact-sql i not understood too, why this query is performed. This is an application that developers they did it with sql server 2005 and the string is built dynamically, and i got it to me to take it to other platforms. I now understand that iff statements in the "where" are not necessary, is true?
elecsvz 17-Jan-15 12:45pm View    
http://i1078.photobucket.com/albums/w482/Eleazar_Celis/Captura_zps58ed6ba3.png~original

in every one
elecsvz 17-Jan-15 12:34pm View    
sorry bruno the error message is: "Incorrect syntax near the keyword 'LIKE'."