comparing strings

treasacrowe · September 7th, 2004, 05:58 AM

Hi i am having a problem with comparing two strings. I am taking
in the parameter rs("Company") and if this is empty i want to put some
text in there. I am testing it with an empty Company field and comparing
it like so:
temp1=rs("Company")
temp2=StrComp(temp1,NULL)

I have also tried it with
temp2=StrComp(temp1,"")
but each time i get nothing returned. Is there some rule about comparing a
string with an empty string?
Thanks a million!
Treasa

rajanikrishna · September 7th, 2004, 06:19 AM

Hi,

  I f you want to compare with empty string, you can like..

  if test1="" then
    'NULL is not equal to ""
  end if

The StrComp function compares two strings and returns a value that represents the result of the comparison.

The StrComp function can return the following values:

If string1 < string2 - StrComp returns -1
If string1 = string2 - StrComp returns 0
If string1 > string2 - StrComp returns 1
If string1 or string2 is Null - StrComp returns Null

Syntax:
        StrComp(string1,string2[,compare])

Where compare is
Optional. Specifies the string comparison to use. Default is 0
Can have one of the following values:

0 = vbBinaryCompare - Perform a binary comparison
1 = vbTextCompare - Perform a textual comparison

treasacrowe · September 7th, 2004, 06:23 AM

hi thanks for replying, i have tried this and it doesn't evaluate true, even though the field company is empty.... very frustrating!

qazi_nomi · September 7th, 2004, 06:32 AM

Can you put the code here So that we can guess it clearly

(*_*)

Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!

treasacrowe · September 7th, 2004, 06:43 AM

hi guys its okay, i got around it by getting the length of the string and make my if statement by checking if this is equal to zero, this works fine. thanks very much though!

happygv · September 11th, 2004, 09:48 AM

Hi treasacrowe,

There no such rule other than this.

When you want to check if the string variable is Empty/Null, you can do that using IsEmpty() or IsNull() functions.

When you decide to use Len(), it is better to always TRIM() that before using LEN(), so that a variable with just some blank white spaces would make you think that it is not empty.

Code:

If Len(Trim(yourvariable)) > 0 then 
    Response.write "Yes, something is there"
End If

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection