469,898 Members | 1,768 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

String and number conversion and comparison

Hi,

I'm writing a website in asp.net(vb) with an access database behind
it. As part of the site I have a table which has stores maximum and
minimum values. These are integers at present. However - I need to
change them to strings so that I can store the string "unknown" if
these are not known.

Problem is that my comparisons >= etc then won't work properly.
Because of the way I am using the db I cannot have a pointer value, eg
-1, and then replace it on the webpage so it would have to be done
usig strings.

I am dynamically generating an sql string from search criteria which
needs to do comparisons using supplied ints. How can I change the way
that sql dos this in the sql search string?

Any help is great,

Cheers,

Steve
Nov 12 '05 #1
1 2200
Monkey Steve wrote:
Hi,

I'm writing a website in asp.net(vb) with an access database behind
it. As part of the site I have a table which has stores maximum and
minimum values. These are integers at present. However - I need to
change them to strings so that I can store the string "unknown" if
these are not known.

Problem is that my comparisons >= etc then won't work properly.
Because of the way I am using the db I cannot have a pointer value, eg
-1, and then replace it on the webpage so it would have to be done
usig strings.

I am dynamically generating an sql string from search criteria which
needs to do comparisons using supplied ints. How can I change the way
that sql dos this in the sql search string?


Why not use a NULL for unknown? Comparisons on NULL values return NULL.
Nulls displayed in forms appear as blanks.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by ken | last post: by
74 posts views Thread by Michael | last post: by
11 posts views Thread by Nobody | last post: by
26 posts views Thread by junky_fellow | last post: by
26 posts views Thread by Neville Lang | last post: by
8 posts views Thread by Salvatore Di Fazio | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.