Hi,
I am currently converting the code from mysql to mssql and have come across some problems.
I have a text input box ($doctext) that searches for a module name.
If a user inputs a search
the sql: => where doctext like '%$doctext%'
If a user does not input anything
the sql: => where doctext like '%'
In mysql I get a return of all the values in the column doctext when, ...where doctext like '%' is executed
However in mssql the null values are not returned, the question I have is how do I code it to return all the values in the column by using a wildard search im mssql?
Thanks
