Advertisement

06.12.2003 at 03:24PM PDT, ID: 20646601
[x]
Attachment Details

SQL - CONVERT STRING TO INTEGER

Asked by sapanjs in Databases Miscellaneous

Tags: sql, convert, string, integer

Is there a command that can be used to temporarily convert a string value in a field to integer?

I.E.

SELECT name, employeeid
FROM users
WHERE employeeid = bob

In this case employeeid is an integer, and bob is a number but stored as a string.  how do you temporarily convert bob to an integer for the sake of the comparison?Start Free Trial
 
Keywords: SQL - CONVERT STRING TO INTEGER
Title
1 How to return the valid previous and n…
2 Integer comparison
3 datetime to integer
4 Bob's Your Uncle
5 Inserting Integers
6 Need an SQL OleDb date comparison
 
Loading Advertisement...
 
[+][-]06.12.2003 at 03:58PM PDT, ID: 8713288

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2003 at 03:59PM PDT, ID: 8713291

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Databases Miscellaneous
Tags: sql, convert, string, integer
Sign Up Now!
Solution Provided By: crescendo
Participating Experts: 6
Solution Grade: A
 
 
[+][-]06.12.2003 at 08:02PM PDT, ID: 8714399

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2003 at 01:00AM PDT, ID: 8715606

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2003 at 01:02AM PDT, ID: 8715609

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2003 at 06:29AM PDT, ID: 8717576

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2003 at 09:25PM PDT, ID: 8722573

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.27.2003 at 11:09PM PDT, ID: 8817860

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.06.2004 at 07:15AM PDT, ID: 10766106

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]04.10.2004 at 04:25PM PDT, ID: 10798915

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]03.28.2005 at 03:04AM PST, ID: 13642726

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.19.2005 at 02:15PM PDT, ID: 14915803

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32