Hello,
Please, could you provide more informations about your problem ?
- the full version of your SQL Server Express ( 2005,2008,2008 R2,2012 + last installed service pack ). It would be useful as each new version is providing novelties in the syntax of the T-SQL ( Transact-SQL ) statements. If you have installed the edition
with advanced services, could you tell us ?
- the structure of the tables in which you are searching data ( the better way would be to provide the full CREATE TABLE statements, including primary/foreign keys and indexes as the use of indexes could give performance )
- have you enabled the full-text search ? Is the Comments field using the FileStream feature ?
It is possible that , if your question or your table structure are a little complicated , a moderator moves your thread towards the TRANSACT-SQL Forum. Only moderators can do this operation. It avoids to have to recreate a new thread, no
lost posts and it will avoid to have a thread dying because it is not in the good forum ( i prefer to wait for the agreement of the original poster that's to say you Igseem before doing the move ) .
We are waiting for your feedback to try to help you more efficiently.
Have a nice day
PS : i have choosen T-SQL for SQL Server 2008 R2 because it is the most common choice ( few differences with SQL Server 2008 and it is the beginning of SQL Server 2012 )
for 'Contains' or 'Begin with :http://msdn.microsoft.com/en-us/library/ms179859(SQL.105).aspx
for Comparison Operators
http://msdn.microsoft.com/en-us/library/ms188074(SQL.105).aspx
For the search of rows :http://msdn.microsoft.com/en-us/library/ms189499(SQL.105).aspx
Maybe, these links could be a start to the creation of your SELECT statement
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.