none
SQL Query Question RRS feed

  • Question

  •  

    I am trying to have my program run some advanced SQL queries that are

     

    1. case sensitive

    2. search for an exact match

    3. partial match at beginning 

    4. partial match anywhere. 

     

    Is it possible to do these queries with Microsoft Acess and if it is not then what is a free Database Program that is compatibile with VB.net and easy to learn.

     

     

    Thanks,

     

    Dan

    Saturday, January 12, 2008 6:11 PM

Answers

  • Hello,

     

    You may use SQL Server Express Edition ( absolutely free )

    Some limits :

    - 32767 databases on an instance ( but you may have 15 or 16 instances on the same workstation )

    - 4GO max for the data files of a database

    - unable to use more than 2 GO of RAM

    - supports only one physical processor ( a quad-core processor is considered as an unique processor and multi-threading is supported )

    - no replication

    - backup less simple than for the standard or higher edition

     

    See the link :

    http://msdn2.microsoft.com/en-us/library/ms179859.aspx

     

    SELECT [Col1] , [Col3] FROM [tablename] WHERE [Col4} = 'soMething'

    that's an example of a "classical" SELECT for a full match

    i put the names of the columns between [] for i'm using column name with spaces inside 

    for example : [objects number]

    the values strings are between '

    I know there' a function which make uppercase or downcase translations and is usable in select

    Have a look to

    http://msdn2.microsoft.com/en-us/library/ms189826.aspx

     

    I'm using Sql Server 2005 Express Instances from 2005 with no problem

     

    I hope that will help you

     

    Have a nice day

    Saturday, January 12, 2008 9:57 PM
  • Access doesn't support case sensitive queries. However, you can work around it by using the StrComp function.

     

    ACC2000: How to Return Case-Sensitive Matches in Queries

     

    You can use ANSI-92 wildcard characters (ADO) to perform partial matches. You can use the Left and Right functions to search for pattern matches at the beginning and end of a string value.

     

    Access wildcard character reference
    Tuesday, January 15, 2008 5:36 PM

All replies

  • Hello,

     

    You may use SQL Server Express Edition ( absolutely free )

    Some limits :

    - 32767 databases on an instance ( but you may have 15 or 16 instances on the same workstation )

    - 4GO max for the data files of a database

    - unable to use more than 2 GO of RAM

    - supports only one physical processor ( a quad-core processor is considered as an unique processor and multi-threading is supported )

    - no replication

    - backup less simple than for the standard or higher edition

     

    See the link :

    http://msdn2.microsoft.com/en-us/library/ms179859.aspx

     

    SELECT [Col1] , [Col3] FROM [tablename] WHERE [Col4} = 'soMething'

    that's an example of a "classical" SELECT for a full match

    i put the names of the columns between [] for i'm using column name with spaces inside 

    for example : [objects number]

    the values strings are between '

    I know there' a function which make uppercase or downcase translations and is usable in select

    Have a look to

    http://msdn2.microsoft.com/en-us/library/ms189826.aspx

     

    I'm using Sql Server 2005 Express Instances from 2005 with no problem

     

    I hope that will help you

     

    Have a nice day

    Saturday, January 12, 2008 9:57 PM
  • Access doesn't support case sensitive queries. However, you can work around it by using the StrComp function.

     

    ACC2000: How to Return Case-Sensitive Matches in Queries

     

    You can use ANSI-92 wildcard characters (ADO) to perform partial matches. You can use the Left and Right functions to search for pattern matches at the beginning and end of a string value.

     

    Access wildcard character reference
    Tuesday, January 15, 2008 5:36 PM