Click here to Skip to main content
15,917,926 members
Home / Discussions / Database
   

Database

 
QuestionRe: SQL on a shared HDD via network Pin
Badboy22TR11-Mar-08 1:39
Badboy22TR11-Mar-08 1:39 
GeneralSQL Select, row with close values Pin
phimix10-Mar-08 21:40
phimix10-Mar-08 21:40 
GeneralRe: SQL Select, row with close values Pin
Khawar Abbas110-Mar-08 22:33
Khawar Abbas110-Mar-08 22:33 
QuestionASP.NET Membership Stored Procedures Confusion [modified] Pin
Brendan Vogt10-Mar-08 20:35
Brendan Vogt10-Mar-08 20:35 
GeneralRe: ASP.NET Membership Stored Procedures Confusion Pin
Christian Graus10-Mar-08 20:38
protectorChristian Graus10-Mar-08 20:38 
Question[Message Deleted] Pin
ZenyukIV10-Mar-08 20:27
ZenyukIV10-Mar-08 20:27 
GeneralRe: sql iteration Pin
Chetan Patel10-Mar-08 23:21
Chetan Patel10-Mar-08 23:21 
GeneralExtracting Specific data from Rows: Pin
Shahzad.Aslam10-Mar-08 20:15
Shahzad.Aslam10-Mar-08 20:15 
Hi Friends,

I am having problem with extracting data from a field which has datatype text in sql server 2005. Following is the two sample rows which contains the field.
1.
TrackID14910417OrderID1019RefReason1019Src21244700309600019SID13640214PayCh13MJA210PurchaseID10218
2.
TrackID145493211Description235USE+IT+UP+AND+WEAR+IT+OUT+-+ODYSSEY17OrderID10210PurchaseID1019RefReason10214PayCh13MJA16UserID23642B942B8-05D0-4447-BEEC-7EF11419368B217CVFDate1019SID13640213TID1019Dst21244700059600

I want to extract TrackID value from above two rows, the length of the values may vary, it might be 8,9 or 10 digits long.

Shahzad Aslam
Software Engineer
Softech Systems Limited

Email: shehzadaslam@hotmail.com

GeneralRe: Extracting Specific data from Rows: Pin
Christian Graus10-Mar-08 20:39
protectorChristian Graus10-Mar-08 20:39 
GeneralRe: Extracting Specific data from Rows: Pin
Shahzad.Aslam10-Mar-08 21:08
Shahzad.Aslam10-Mar-08 21:08 
GeneralComparison between MySQL, Interbase and Firebird Pin
dolphinhk10-Mar-08 17:10
dolphinhk10-Mar-08 17:10 
GeneralRe: Comparison between MySQL, Interbase and Firebird Pin
Christian Graus10-Mar-08 20:40
protectorChristian Graus10-Mar-08 20:40 
GeneralMissing SQL Functionality Pin
Jamie Nordmeyer10-Mar-08 11:06
Jamie Nordmeyer10-Mar-08 11:06 
GeneralSend a datetime value to an access datebase Pin
Dan Neely10-Mar-08 3:51
Dan Neely10-Mar-08 3:51 
GeneralRe: Send a datetime value to an access datebase Pin
Dan Neely10-Mar-08 4:43
Dan Neely10-Mar-08 4:43 
QuestionDefault Value Pin
Brendan Vogt10-Mar-08 3:44
Brendan Vogt10-Mar-08 3:44 
GeneralRe: Default Value Pin
Colin Angus Mackay10-Mar-08 4:54
Colin Angus Mackay10-Mar-08 4:54 
GeneralSql Server Reporting Services report problem [modified] Pin
Andrei Ungureanu10-Mar-08 2:53
Andrei Ungureanu10-Mar-08 2:53 
GeneralRe: Sql Server Reporting Services report problem Pin
Paddy Boyd10-Mar-08 3:11
Paddy Boyd10-Mar-08 3:11 
GeneralRe: Sql Server Reporting Services report problem Pin
Andrei Ungureanu10-Mar-08 3:20
Andrei Ungureanu10-Mar-08 3:20 
GeneralRe: Sql Server Reporting Services report problem Pin
Andrei Ungureanu10-Mar-08 3:32
Andrei Ungureanu10-Mar-08 3:32 
GeneralQuerying from an Excel Workbook using OleDbAdapter Pin
moon_stick10-Mar-08 1:37
moon_stick10-Mar-08 1:37 
QuestionQuery to Copy a table from one database to another Pin
Krazy Programmer10-Mar-08 1:23
Krazy Programmer10-Mar-08 1:23 
GeneralRe: Query to Copy a table from one database to another Pin
Blue_Boy10-Mar-08 1:45
Blue_Boy10-Mar-08 1:45 
QuestionGetting records while using inner join Pin
ONeil Tomlinson10-Mar-08 0:49
ONeil Tomlinson10-Mar-08 0:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.