Case sensitivity -
Does anyone know if SQL Server is case sensitive? I ask this because when I perform comparisons between string variables and fields in ADODB Recordsets case does not seem to matter. For example, if I compare hello and HELLO, they are considered the same string. However, my application needs to be case sensitive.
Does anyone know what could be happening, and how I can "turn on" this case sensitivity?
I think it may have something to do with the Option Compare statement, but by default it should be a binary compare.
TIA,
Nahid
Case sensitivity -
Does anyone know if SQL Server is case sensitive? I ask this because when I perform comparisons between string variables and fields in ADODB Recordsets case does not seem to matter. For example, if I compare hello and HELLO, they are considered the same string. However, my application
Disabling case sensitivity... -
Hey Guys!!
How do i disable case sensitivity in vb.net.
Users enter a letter (keypress event) which is then compared to the one from a randomly selected word in a txt file. In the txt file my words start with capital then small letters.
Eg House , but when a user inputs h , it's n
A Replace Function with no Case Sensitivity -
How do I use a replace function with no case sensitivity?
a little help in case sensitivity -
in my program, i have a textbox that specifies what data i will be searching in the database and diplaying it in the flexgrid... my problem is that it is case sensitive. How can i make the searching case insensitive? any ideas!?
Question on Enum case sensitivity -
I ran into a strange situation that I want to stop in VB6
Here is some simple code in a form modules:
Option Explicit
Enum xxxType
enmHello = 3
End Enum
Private Sub Form_Load()
Dim iReturn As Integer
iReturn = enmhello
End Sub
If I hit enter on the line
SQL Server '05: FullTextSearch Turn Case Sensitivity On and Off -
Hi,
I using FTS and namely containstable with SQL Server '05. My db is set to be case insensitive, 99% of the time this is perfect, but my users would like to be able to choose to perform searches with case sensitivity turned on. Is it possible to specify it on the fly?
With regu
Mouse Sensitivity -
Does anyone understand how I can play with mouse sensitivity, or any idea's related to the subject.
I can't come up with anything except to maybe minus a certain number off the movement you make. So if from the middle of your mouse pad to the end shows the Mouse.X has moved 300, I
case sensitivity in stored procedure -
Dear sir,
i am writing a stored proc. in which i have to compare a variable as given below.
case when @dd='a' then '%'
case when @dd='A' then '&'
i have passed 'aA' value to the procedure it returned %% instead of '%&' please advice.
regards
D.M. Kamath
Case Sensitivity and Access - Resolved -
I am trying to do a find on an access database with a like statement. But I can't force it to do it with so it is case sensitive.
select Name
from UserId
where Name like '%Alb%'
This statement will get all names with an 'alb' in it not the only ones that have a capital 'A
[02/03] Password case sensitivity -
in my application; when i give password(valid) it always login no matter it's in capital letter or lower letter. I mean how can i make my application to identify case sensitivity of password. i'm getting login info from database (Sql server 2000).
e.g. if valid password is "sam12
How can you use instr to search within a string without case sensitivity -
Anyone know?
How do I remove text case Sensitivity -
I have 1 text box & command button
Does anyone have a very short simple piece of code that will make the input in the text box non sensitive to the text Case used ?
ie. it doesn't matter whether upper or lower case are used. Either can be used for any letter in a string
keyboard sensitivity -
halu,
i'm kinda new to this VB.NET thing and i want to know something about keyboard sensitivity. let's say pressing Ctrl Alt Shift ESC with close the program... i know something about the form_keydown but correct me if i'm wrong, it only handles one key event... like ESC closes the
Theory of Sensitivity Testing -
I have a program that creates a pool of equations with some variety of variables. I want to test the sensitivity of each equation to fluctuations in any of the variables. Basically, I haven't gone looking for some standard approach, but have been playing with different measures of sens
Find case senstive Records from Access -
Hi people,
I'm tryimg to find records from an Access table, where the record should be case sensitive to the request.
eg: Select word from Dictionary where word ='A'
In the table, there may be 'A' as well as 'a', but the recordset returned to me should contain only 'A'. I'm not
File exists - case insensitive -
Hi all,
I want to know whether any vb function is available to find whether file exists. The function should also check whether file name case sensitivity.
FileExists method returns true, if I give the input as "SampleImage.jpg", but actual filename is "sample
Case Sensitivity in .Find methods -
I am doing a .FindLast on a recordset and expect the search to be case sensitive. However, it appears not to be. I played with Option Compare (whose default is supposed to be binary) and found that that didn't help. Even when I explicitly include Option Compare Binary, it fi
case sensitivity sql {Resolved} -
i have tried to use a sql statement from antoher thread i found in vbforums.com ( http://www.vbforums.com/showthread.p...+sensitive+sql )
mySQL = "SELECT brugernavn, password, admin FROM brugere WHERE CONVERT(varbinary,brugernavn) = CONVERT(varbinary,'" & strUsername &
SQL Question: Select case sensitivity. Resolved -
SQL> select * from retailer where contact_person = 'john';
no rows selected
SQL> select * from retailer where contact_person = 'John';
ACCOUNTNO ADDRESS PHONE FAX
---------- ------------------------------ ---------- ----------
CONTACT
string comparison help -
I'm going through and parsing an html file and I'm looking for all occurances of "<table". However, the problem I'm running into is that sometimes it's "<Table" or "<TABLE" which when using a Mid() function such as:
If Mid(msHTMLData, lPos, 6)
still problem with ini files -
this is the result i want:
[SCRIPT]
Sub defNat(avInput, avOutput)
Select Case UCase(avInput)
Case "01" avOutput = "België"
Case "06" avOutput = "Nederland"
Case "07" avOutput = "Groot-Brittani
[2008] XBOX360 ION Drum Rocker to MIDI converter -
Hello, i'm beginner in .NET, but i wrote small programm based on joyGetPosEx which read ION Drum Rocker commands as gamepad events and converted it to midi notes signal to MidiYoke or other virtual midi cable.
With this program ION Drum Rocker xbox360 drums with cymbals can be used as
Select Case confusion -
if i have a select case statement that looks like this:
for i=1 to 12
Select Case i
Case Is = 1 Or 2 or 3 or 4
.y = 100
Case Is = 5 Or 6 Or 7 Or 8
.y = 200
Case Is = 9 Or 10 Or 11 Or 12
.y = 300
End
Mouse speed -
Is mouse sensitivity scale same with all mouses (Are Logitech, Microsoft and others are using their own settings)? If yes, how can the current value be retrieved?
Better LOOPING structure -
Can someone give me a shorter code structure for this loop?
thanks
Code:
do until rsSec15.eof
select case rsSec15("ResponseID")
case 227
strCheckB227 = "checked"
case 228
strCheckB228 = "checked"
case 145
Select Case it isn´t working -
I´m trying to compare time using the next code
fec = Now
Select Case fec
Case Is > #8:29:00 AM# And fec < #9:01:00 AM#
-----------------
----------------
Case Is > #9:00:00 AM# And fec < #1
[Reezolv'd] Syntax Question --> Case -
Hello.
I've got a line like this:
If x>0.5 and x=<1 Then
Blahblah
End If
How would it be with Case?
Select Case x
Case Is >0.5 and Is =<1 - didn't work
I tried some other combinations but nothing worked.
How do you build this using Case?
Best
Split digits into words code shortening -
I am using the following code to spell digits in words:
Code:
Function sdw(ByVal dig As Integer) As String
Select Case dig
Case Is = 0
sdw = "ZERO"
Case Is = 1
sdw = "ONE"
Case Is = 2
sdw = "TWO"
Case Is = 3
sdw = "THREE"
Case Is
im trying to cut back on some code... -
im useing something like this but i have 50 cases! does anyone know how i can make this a lot smaller?
Public Sub nextlvl(lvl As Integer)
Select Case (lvl)
Case 1: Call Form1.puz2
Case 2: Call Form1.puz3
Case 3: Call Form1.puz4
Case 4: Call Form1.puz5
Case 5: Call Form1.puz6
case select -
Working with 'select case'.
example :
case 1
frmHelp.show
statements
case 2
frmBill.show
statements
case ...
Now I'm executing the statements in case 1. On the form in case 1 I have a button 'next'. If I click on that button I want to execute the statements which are d
Case statement -
Can any one give me an example of case statement
This is what i am using whats wrong with it ..
case number
case 1 getTeensNumber = "get"
case 2 getTeensNumber = "Twenty "
case 3 getTeensNumber = "Thirty "
To graphicy type people... -
Hello
I want to buy a graphics tablet and would like to know if anyone could recommend a good one.
I'm no pro graphic artist or anything, so I just want a decent one with pressure sensitivity and preferably about A4 size. Are Wacom ones the best? I don't want to pay to much t
Select Case Question -
Ok I have 14 text boxes and for each of them I need to make a long select case like below
is there something I can add to this select case so I dont need to copy it 14 more times and just change 1 thing???
I mean all the case's are the same I need to just change the name from rs.text
Question about Select Case -
I have 10 possible cases and three of them result in the same action. How can I write that same action only once. Here is an example
Select Case variable
case 0
code for doing a here
case 1
code for doing b here
case 2
code for doin
[2.0] Switch case -
I'm getting an error for my switch statement: "A constant value is expected"
Here's the code:
Code:
switch (true){
case prefixText.StartsWith("a"):
case prefixText.StartsWith("b"):
case prefixText.StartsWith
Select Case problem. -
Hi friends,
Can anybody post the syntax for selecting .value property of checkbox as selectcase in VB6.
I want to do something like
Select case .value = 1
case Check1
Do.............
case Check2
Do...........
case Check3
Select Case Help -
I'm trying to convert the numeric value is Text4 to the letter values I put in this Select Case. Mine will only change the first character, not all of them. In other words: 568124 in Text4 would equal BPGDXY in Text5. Anyone know how to change them all? This is not meant to be enc
problems with CASE -
hi
i have quite a few case statements to write, I know its possible to do it with a loop but the point of the excercise is for me to learn CASE....
there is an array of variables, "varsquare" that goes from 0 to 8, thats 9 elements. Each element can take the values &quo
RESOLVED Select Case -
I must be having a mental block, how do i do a select case to see if a number is between two other numbers
select case a
case is > 5 and is < 10
' I want this to return on 6,7,8,9
case 88
case else
end select
help with numtotext -
hej all,
I'm writing a numtotext application to convert 6 digit number to text but i'm stuck, i keep getting "zero thousand zero hundred zero ten ten one" for example instead of "eleven"
anyone who can take a look at the code and help me a bit?
i think i'm almo