Query Commands

Hot Topic

error in local variable
Verify Function Signature at compile time using System.Attributes
How to import a dll made in C++ Win 32
VB.net verses C#. Which is used more. Which more popular
Opening CD tray from C#
How to make C# & PHP interact with each other
How to get parameters in a web form?
import csv data into database
Visual Studtio 2005->File->New Project->Shows an empty box
Problem With Indexing Shared Nework Drives

Visual C#

Multi-tiered enviroments planning for MOM 2005
Passing data between class and form in C#
DateSerial Value
Moving to Vista
Components parameters
big file storage in sql
c#
DOS window doesn't close after process started?
How can I do to use Windows API?
Which ROW in DataSet gave error?

Query Commands

Ok. I am trying to use the query command "LIKE", but its not working. I have a row with the name Ben Stuart - A moment inside. When I use the following code:

SELECT * FROM TableName WHERE Title LIKE ' e*';

and its not working, it just shows a blank table. But when I use the following code:

SELECT * FROM TableName WHERE Title LIKE 'B%'

..then it works just fine. I know the first block of code is to match the criteria to the second letter, and the second block of code is to match the search criteria to the first letter. I just cant seem to get the one where it searchs for the second letter. Can someone help


Answer this question

Query Commands

  • PlusOne

    SQL does not work on Regular Expressions.
    It will work on special wildcard characters only (they being %, _ [underscore], square brackets [], and [ ^ ] to signify the characters not to include).

    You could use underscore because this works on the same format as * ... rather than actually.
    You can make it:-  LIKE '_c%'
    This will look for any word that starts off with any character but has c as the second character and does not care about any occurrence of the characters thereafter.

    I hope that solves the problem.


  • Markchr

    Thank you for that clarification. Could you also tell me how, when I perform a query, for the row width to be increased. The width always seems too short.

  • Urue

    Didn't quite get your question over there. Do you mean you want to change the width of the column from a web application or the SQL database itself. In my case, I tried from SQL, it works just fine, changes the width according to the data output. If you are talking about web applications then change the column setting to be "auto".

  • Query Commands
Answer this question