Getting Char(12) to Numeric - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Getting Char(12) to Numeric

Message

From

27/03/2011 15:34:07

Kevin Goff
Pennsylvania, United States

To

27/03/2011 15:30:57

Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Getting Char(12) to Numeric

Environment versions

SQL Server:

SQL Server 2008

Application:

Web

Miscellaneous

Thread ID:

01505130

Message ID:

01505134

Views:

58

This message has been marked as a message which has helped to the initial question of the thread.

OK....well, one way is to use the sql REPLACE to convert the hypens to a blank...somethign like

cast( REPLACE(Telephone, '-','') as int)

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313

Click here to load this message in the networking platform