• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

using cast or convert in assces 2005 query to convert a text field to integer

I have a linked table to an as400 db the field on the as400 is a text  field i have a query that needs to compair the value from the as400 to an INteger(number) how so i use a cast  or convert function in my asscess 2005 query

select as400.PONum from as400

in sql i would just select cast(as400.ponum as int) as ponum but it does not work in acess 2005
0
LeeHopkins
Asked:
LeeHopkins
1 Solution
 
cquinnCommented:
select CInt(as400.PONum) from as400
0
 
nico5038Commented:
Try:

select Val(PONum) as numPOnum from as400;

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now