B bugsy Registered User. Local time Today, 02:36 Joined Oct 1, 2007 Messages 99 Nov 20, 2007 #1 in the query design how can I extract a number out of string. ex 25 bp 234.56 bp etc. ? I would have expected INT(FiledName) but it's not it
in the query design how can I extract a number out of string. ex 25 bp 234.56 bp etc. ? I would have expected INT(FiledName) but it's not it
pbaldy Wino Moderator Staff member Local time Today, 02:36 Joined Aug 30, 2003 Messages 36,157 Nov 20, 2007 #2 You can use the Left function along with the InStr function to find the space.
B bugsy Registered User. Local time Today, 02:36 Joined Oct 1, 2007 Messages 99 Nov 20, 2007 #3 pbaldy said: You can use the Left function along with the InStr function to find the space. Click to expand... i was planning to do that; but i wanted t ocheck first if i can just extract the number.
pbaldy said: You can use the Left function along with the InStr function to find the space. Click to expand... i was planning to do that; but i wanted t ocheck first if i can just extract the number.
J Jon K Registered User. Local time Today, 10:36 Joined May 22, 2002 Messages 2,209 Nov 20, 2007 #4 I would have expected INT(FiledName) but it's not it Click to expand... You can use the Val() function instead of Int(). .
I would have expected INT(FiledName) but it's not it Click to expand... You can use the Val() function instead of Int(). .
