any string compare functions in sql server -
Hi all...
There's this StrComp function in Access but anyone knows if there is a similar string compare function present in sql server?? What's the command if there really is?
Thanx in advance.
any string compare functions in sql server -
Hi all...
There's this StrComp function in Access but anyone knows if there is a similar string compare function present in sql server?? What's the command if there really is?
Thanx in advance.
[resolved]case-insensitive string compare -
Quickie - just looking for an existing function to compare example and eXamLe which will return true, without having to overload string.compare functions.
Tall order (String->Int // Int->String) -
I am developing an online quiz, part of which required short answer questions (1 word for now).
I am trying to write a function which will compare the input word with the correct word.
I am using a 'confidence level' to determine if they are close enough to be correct - I have to
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
.wav comparison -
Say I have two .wavs and I want to compare them. Are there any functions that can tell me when a certain sound is lower or higher, or things like that? If you break them down into some kind of binary can you then compare the numbers?
VB - Some functions that makes string parsing easier -
The next functions makes string parsing a “piece of cake”.
The first word in the function names, is how the function does the search (ie Left = Instr and Right = InStrRev), and the right word of the function is what part of the string the function returns...
These functio
How to compare multiple (part) strings -
Hi,
I have 2 listboxes and want to compare both and count in how many lines are identical strings. BUT .... I want to use part of the strings (same as with MID) and this part strings chance always.
For example: I want to compare at the begin the characters 1-5 then 2-6 then 3-7 a
compare string regardless of upper or lower case (Resolved) -
Hi,
I have got to compare a string with another string. How do I compare both string irregardless of case sensitve. Below are a few examples
star = Star
Star =star
matching should be done based on case insensitive.
How to compare 2 strings -
Hi!
I have a memory block where are many strings, but I cant compare them with a constant string!
Example:
"if" statement is using sizeof() and its not using strlen()
Is there some functions or do I need to make a for loop (which is slow) for checking the data?
Code:
SQL Server Level Functions -
Is it possible to make server level functions, and how ?
Right now I have a function at database level, and I was told that it can be moved as server level so all databases on the server can access the functions.
So, how can it be done ?
compare a item in a collection -
I want to compare a string item in a collection with another string variable. I use collection.items.contains(string_var) to compare if the string_var is in the collection. But i need to compare case insensitive !! How can i do this ?
HLP!!! Msvbvm50 Functions -
Hi, I'm Proaudio and I have a problem!!!
I'm looking for a list + description of Msvbvm50 functions.
Some functions like vbastrcmp are very easy to understand (string compare), but other are mysterious fo me!
Where I can found it???
Many Thanks...
Bye Bye
Compare String in FlexGrid Cell to Excell Sheet Cell -
I have a string in a cell of a flexgrid that I want to compare to a string in an excel sheet cell
I tried doing this:
MsFlexGrid1.Col=0
MsFlexGrid1.Row=0
If MSFlexGrid1.Text = XLSheet3.Cells(3, 1) Then
'Do the stuff I want to do
End If
But it gives me a runtime error a
Binary / String Comparison Question... -
I want to compare a binary field against a text field...any thoughts on how to do this? I can't find any functions to convert a binary to a string...
TIA
useful study guide for VB.6 -
Hi all,
i am new to VB.6 . now i just wanna play with a testing program . the background is i type some character string randomly in textbox 1 , after i click a command button, the VB program will check the string in textbox1 character by character. once it detect the character 'h' it
Storing End-User Passwords In SQL Server Tables -
I am building a web application using SQL Server and VBScript ASPs. I would normally use CAPICOM to hash the passwords and store them in a user table. When the user wants to log in, I hash the string he supplied during the challenge and compare it to the value stored in the DB.
Th
how to compare sql timestamp -
Hi,
I use ADO.NET to retrieve a table from sql2k server, where one of the field is timestamp type.
I want to compare this field for concurrency checking, but I found that the value returned by ADO.NET is an array of byte.....can I just convert it to say Long, or I need to compare i
Parsing a string.. -
Hello,
I have textbox in which I am typing. In the textbox_change() event I am passing the contents of the textbox to a function. For example if I type a "D" then I pass that as my string. When I type "A" then "DA" is passed...so on and so forth. In the
question about date field -
Hi,
I use date picker to let user pick the date and use that date to get a recordset from the SQL server and the field that I try to compare in SQL is defined as datetime stamp field. Do I have convert the dtpicker.value to date format first in order to compare the datetime stamp f
[SQL] Splitting a string -
Using SQL Server 2000.
Given a string, like PassFatality, how would I split this into Pass Fatality using SQL's string functions?
Option Compare Text at Runtime -
By inserting option compare text, str comparisons become non case sensitive.
I need to know how at runtime I can switch between binary and string comparisons?
I can do it the messy way by optionally running a ucase or lcase statement to both string to be compared, however this be
Compare each string with strings in array -
I need to search an array of strings and compare each string with a given string.
I count how many characters in the string that equals the string of the array.
In the beginning the array is empty. Depending on the result of the compare the array grows. That means that the array
help with DateTime.Compare -
hi! can anybody please help me. Why is it when i try to compare two the same dates I was not getting the right return value of Datetime.Compare which 0. I dont know if the problem is in my code or is in the Datetime.Compare method. by the way, i attched a screenshot to give you more id
About Comparing String -
When I comparing string for match or unmatch, how do I know where/ it's unmatch
for example when I compare "ABDD" and "ABCD" the function will reply character number 3 is unmatch
I have to compare about 100.000 characters, so compare each character isn't a good id
complex string comparison -
Hi all,
I want to compare 2 strings of text (product description)
example:
string 1: Cup. knee 12mm x 15mm cap. 90degr.
string 2: VSH knee 12mm x 15mm 90 / cap.
these 2 strings represent the same product (different suppliers)
is there a way to compare the strings word by
How to do File/Version comparison -
Hi,
I was wondering how I can compare two files to see if they are the same. I'm looking specifically to compare the application file that is local with one that is on the server to see if they are different. Thanks.
Request: Simple Step-By-Step Remoting How-To -
Hi,
Here's my problem. I have written a vb.net DLL which contains some key functions - at the moment I have a winforms application which hooks into it and can run the functions (which works). (fyi it inherits marshal by reference)
However, the functions have to be run from a spec
VB.NET: Using String to compare with the Combo Box... -
Hi...
Say i have this string call "data" in Form1, this string contains number "5" value....
how do i pass this string to the Form2 and compare with the combo box items...
The combo box DropDownStyle is set to DropDownList...
which means when i pass, the
SQL Jet functions -
Does anyone know what functions (especially string functions) the Jet engine can cope with?
Ive tried Mid, right, left, instr and loads of others but cant find any that work. The error is always that Jet doesnt recognise the function.
Ive tried looking round on the web for a list
sqlquery to compare a given date with datetime field in a table. -
hi,
how to compare a datetime field called date1 with date part alone.
i want to compare the date part of the column with date input to select the matching record.
show me the query. I want this as a stored procedure in sql server 2000 to access in my prg.
compare a string -
I have a string value and I want to compare it with some words.
What I want to do that first program read the string value and if it contain "abc" (without quotes) in whole string then it call x function but if it contain "xyz" call y function.
Basicaly i want
Option Compare -
Can anyone give me some insight as to the benefit of using option compare.. i pretty much know what it does.. and that it is compare binary by default... but when should you use option compare text instead?
How to compare one string to.....HELP!! -
Hello,
I'm trying to compare 2 strings(username, and password) to a textfie that I have loaded into my app, via richtextbox.
If there is a way to compare it without using the richtextbox that is cool. I have a textfile that has the usernames and accounts of my users in it. I get the
Arrays vs. multiple functions -
If you have a string that will be split into three specific pieces of information, what is the best way to partition this string? As individual functions, pass the string to one function and return and array with the three sub-strings, or is there another method?
Thanks
Fast Compare -
Dear All,
I have two Richtext box in Form . I have typed some word in Each boxex.These Text boxes has arround 100 - to 150 lines each.
I want to Fast Binary compare method, which will highlight the First Mismatch with some colour in Each Text box.These Compare sh
easiest way to compare 2 lists -
what is the syntax for using the compare in vb... ie compare filelist1 to filelist2 and see what files one directory has that the other doesnt
Compare Database -
Not sure if this is the right place, but I'm pretty stuck. I have 2 pretty large list ... like 1 million plus records & 10 Million plus.
One of them has a bit older data but I want to compare it to the new one and confirm the data.
The new one contains the 10 Million recor
[VC++ 2008] Declaring functions and variables -
Ok, I would like to know how to declare functions and variables in Visual C++...
I know this one
int tempInt = 0;
however, no others work, there's no such thing as a button, a string, nothing LOL?
functions>>
public:
static int I2S(String^ str)
{
}
Easy one: string/char comparison -
I need to compare two character array elements to see if they have the same value, but using a text compare rather than a binary compare of the scan codes. I want to do what VB's Option Compare Text does rather than Option Compare Binary, which is what I am seeing as a result of this c
DateComparison Problem!!! -
Hi!!!
I am trying to filter the records in my recordset, in which the filter column is smalldatetime. the problem is when i write the filter string i need to compare the datetime column value (only date not time) with the available date. I dont know which function in the sq