Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and ...

This all works fine as is but a long search string will increase the size of the function call result to greater than 1000 and so @searchPhrase gets truncated and the sproc fails. I can up it to ...

If you’re looking for a solid “Hello World” sample application, then check out the tutorial to build the Java code that enables you to search for a string in SQL Server using a regular express (regex) ...