I have a column within a table with date like 25C1, 26B1, 345SS4, 432BRP5, ect........
I need the remove the numbers both front & back and leave only the letters.
Like C, B, SS, BRP...........
The letters will be in a new column.....
Thanks
Remove Numbers
Hot Topic
- Customer Count
- Deleting users and recreating
- I hate this
- Moving or rolling average, how to?
- How to detect if a table has a FTS Catalog - SQL Server 2005 FTS
- Cannot figure out how to write this script?
- NS 2.0 and SQL Server 2005?
- SSSB Error Message
- More details
- Problem with plug-in algorithm in SQL Server 2005
SQL Server
- Can OWC 11 work with SSAS 2005 cubes?
- SQLSERVER 2005 Sept CTP BACKUP AND RESTORE Transactions
- XML query output to File in SQL Server 2000?
- User Defined Number Generator
- SSIS: Exec SQL Task: Capture return code of stored proc
- SSIS Package failing to disconnect?
- NET Framework error occurred during execution of user defined routine or aggregate 'getSalesOrdersHeaders'
- SQL Server 2005 Express Edition install failed (bundle with VS 2005 RC from 9/12/2005)
- Is it possible to deploy reports on server and view it from client machines
- Dataflow where sourcecolumns vary ?
Remove Numbers
withersd
If you're familiar with ODBC, you can call SQLColumns( ) on the table name, and then SQLFetch( ), SQLGetData( ) to get each column name in sequence. Then you can parse each column name character by character, skipping characters until you come to a non-numeric character, and append that character to your column's name.
The problem with what you're trying to do is the risk of duplication. For example, 25C1, 3355C89, C12345, will all result in the same column name.
Here's a link on MSDN to SQLColumns( ):
http://msdn2.microsoft.com/en-us/library/ms131413.aspx