SELECT TO_NUMBER(ZIP_CODE)
FROM ACCOUNT;
SQL Server:
SELECT CAST(ZIP_CODE AS INT)
FROM ACCOUNT;
You can also use CONVERT function in SQL Server
Saturday, April 11, 2009
Convert to number
Subscribe to:
Post Comments (Atom)
About Me
- タオ チューン
- I love information system such as ERP, CRM, SCM, HRM, Accounting, etc very much and would like to share my knowledge about ERP, CRM, HRM, SCM, ... which I knew to everyone.
Popular Posts
-
The following query gets vtigerCRM Contact List SELECT t1.contact_no , t1.firstname , t1.lastname , t1.title , t4.accountname , ...
-
1. Download ODBC Driver at this address http://www.postgresql.org/ftp/odbc/versions/msi/ Choose the suitable version with your PostgreSQL ...
-
You have two SQL Server 2005 computers. One server is SQL1 and another is SQL2. You need to access SQL2 from SQL1. You have enough permissio...
-
If you want to use a single query to replace multiple spaces with one on SQL Server, you can read the articles here http://www.sqlservercent...
-
Go to Pligg website to learn more. CREATE TABLE `pligg_comments` ( `comment_id` int(20) NOT NULL auto_increment, `comment_randkey` i...
-
Your company uses a SQL Server database to manage data on e-Commerse site. This database contains a trigger named tgInsertOrder, which fires...
-
If the stored procedure is not encrypted , you can use this extended stored procedure: sp_helptext 'StroreProcedureName' You can fin...
-
What will be the output of the following script? SELECT RTRIM('TestxxXXxxx','x') FROM dual; A. Test B. TestxxXX C. Te...
-
SELECT name, context, unit, setting, short_desc FROM pg_settings WHERE name in ('listen_addresses' ,'max_connections'...
-
Life Quote : The difficulties, hardships and trials of life, the obstacles...are positive blessings. They knit the muscles more firmly, and ...
No comments:
Post a Comment