Case senstive problem

[Agnes]

I found that store procedure with vb.net (seems ignore case senstive)
I type "lax" as code, and it returns the correct answer , How come ??
I can't set the upper case in that textbox, BUT I need to check the data
'case'
Please help

 

[Cor Ligthert]

Agnes,

All text between "" is mostly case sensetive by instance datatable names in
datatables.

SQL strings in opposite to that are not case sensetive.

Is this the problem you are pointing on?

Cor

 

[Herfried K. Wagner [MVP]]

I found that store procedure with vb.net (seems ignore case senstive)
I type "lax" as code, and it returns the correct answer , How come ??
I can't set the upper case in that textbox, BUT I need to check the data
'case'

The case of what data? In the database? Can you be more specific
and/or post some code you are currently using?

 

[Agnes]

my code is
(1)select * from portTable where portcode = 'lax'
(2)select * from portTable where portcode = 'LAX'
both statment return the TRUE answer, I wonder statment (1) should return
nothing to me

 

[Cor Ligthert]

Agnes,

Any reason why you are ignoring my answer I gave already yesterday on this
question before the answer from Herfried?

However I think I will ignore your questions at least for a while.

Cor

 

[John Wadie]

Change your query to

SELECT * FROM portTable WHERE portcode = 'lax' COLLATE
SQL_Latin1_General_Cp437_CS_AS

The default installation of SQL Server is case-insensitive, so you need to
specify the collation explicitly in your query. Take a look at "Specifying
Collations" in SQL Server books online.

Cheers,
John Wadie

 

[Agnes]

Cor,
I won't ignore any response in this newsgroup. Herfried K. Wagner asked me
to post my code , that's why I post my stupid codes here.
I am sorry that you ignore my post.

 

[Cor Ligthert]

Agnes,

I won't ignore any response in this newsgroup. Herfried K. Wagner asked me
to post my code , that's why I post my stupid codes here.

And did you get an answer from him, I had answered your qestion 8 hours
before H however not any reaction from you.

And was exactly as showed with your code.

So I do not understand why you had to sand the code.

Cor

 

[Herfried K. Wagner [MVP]]

And did you get an answer from him, I had answered your qestion 8 hours
before H however not any reaction from you.

And was exactly as showed with your code.

So I do not understand why you had to sand the code.

Cor, it's not up to you to decide what other people should do and what
they should not do.

 

[Cor Ligthert]

Herfried,

Cor, it's not up to you to decide what other people should do and what
they should not do.

Beg your pardon, are you telling me what to do, I did not tell anybody what
he or she should do in this thread. I was asking whys.

Are you the one in this newsgroup who has to forbid that?

Cor

 

[Herfried K. Wagner [MVP]]

Beg your pardon, are you telling me what to do, I did not tell anybody what
he or she should do in this thread. I was asking whys.

You said that you don't understand why Agnes provided more information.
It's your right to post that to the group, but I think that everything
has been explained by Agnes...

Are you the one in this newsgroup who has to forbid that?

Everybody can spam the group. I remember the name of a spammer who
posted quite frequently but then leaved the group over night.