I have an sqlstatement
Select * from tblusers where name = txtname
This sqlstatement is not case sensitive, it gives me a match even when
name = Martin and txtname = martin. I don't want it to return a match unless it's exactly the same.
well the ideal way to handle this is follow a uniform data storage in the database, that will give more control over the database.
You should always follow proper casing when storing the data back to the DB.
If you want to be able to compare two case-insensitive strings and have the comparison be false when the two strings are the same except for the case of the characters then you need to use the COLLATE clause when comparing the two strings.
Do something like this
Select * from tblusers where name
Just a flash back. Are you using MsAccess Database? You can find SQL Query Analyzer only if you have SQL Server installed on your machine. Iam guessing at this point that you dont have SQL server installed.
found it, not sure which of the following describes the version, either
sql 800.194 or
and yes I am using msaccess database and all my sql statements work, even this one worked, my only problem in this case is it is not case sensitive
ok! good atleast you got a work around. But that should have worked in one statement as I would like the program to be as light as possible.
Let me know.. You can register on my site for more tech artciles. click here
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.
I am writing a java program that needs to execute shell commands, so I wrote a function that would take the command to execute as a string (ie: "mkdir ~/Folder1") and execute that command with the shell. Here is the function:
Runtime run = Runtime.getRuntime();
Process pr = ...
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...