Hi,
I have a question and would like a recommendation:
I have a situation where i have string "tempstring" and
if i do the following conditional
Please Login or Register to view this content.
it seems to work......and i dont know why? if i change assignment to tempstring = "0" then it still works. Dont know why.Please Login or Register to view this content.
Also, i was thinking that it would not work and that i should convert the string to a number first but if it works should i?
No necessarily!
If you are comparing the same data type-string with a string or a number with a number, you do not need to convert one to another. However, if one cell is formatted or declared as a string, another one as a different data, they will not match.
A lot depends on what "greater than" and "less than" mean to you.
As text strings: the text string "2" is greater than the text string "10"
As numbers: the number 2 is less than the number 10.
The examples you give just happen to be the same whether as text string or as number, but there are definitely examples where they are not. You as the programmer will need to understand how number sort order and text sort order are different and will need to decide which is more correct for you situation, or if it really matters at all.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks