Solved

Convert

Posted on 1998-09-29
1
588 Views
Last Modified: 2013-12-25
I need to convert a variable from a varchar to an int. I am requesting a username from a website. this username is actually a number. It needs
    to be checked against the SQL table which stores the username as an Int. What would the syntax be. This is what I tried, but failed.

    User = Convert("Individual","Username",SQL_Int)

    Todd Yolish
0
Comment
Question by:yolish
1 Comment
 
LVL 10

Accepted Solution

by:
MasseyM earned 50 total points
ID: 1855336
Use:

User = CInt(Username)

where Username is the number in Char format and User will be ne number in Integer format.  This example is in VBScript.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Accessibility and Usability are two concepts that seem to be closely related.  But, too many people seem to have a distorted perception of them. During last five years, those two words have come to the day-to-day work of almost every web develope…
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now