SELECT *, PATINDEX('% %',LTRIM(RTRIM(cDigitsDialed))) FROM CallTrace

I am able to the first count of chars before the space using this, but just the first set, if there is more than...

I have attached a flatfile with the data I am processing in SSIS and inserting into MitelCallTrace, then parsing it and inserting it into CallTrace.

I have posted the create tables.

I don't need to parse the MitelCallTrace table that is a staging table I am inserting the data from a flatfile into, I am processing the parsed data in CallTrace...

No that didn't work, all it did was return NULL values for every column 1 through 10

Yes, I am not looking to count the spaces, I want the count of characters before each space, I can find the spaces, but I am needing for example 777...

Yes, I am not looking to count the spaces, I want the count of characters before each space, I can find the spaces, but I am needing for example 777...

J Livingston SQL (6/12/2014)

---

cbrammer1219 (6/12/2014)

---

These are phone numbers, and I am using them to determine if it is a inbound call or outbound,

For example....

3333 917899999 3210

3333 is the extension...

Let me apologize for the poorly formatted result set now, new to the forum and not sure how to format, but the underlined values(cDigitsDialed) are the ones I am trying...

Let me apologize for the poorly formatted result set now, new to the forum and not sure how to format, but the underlined values(cDigitsDialed) are the ones I am trying...

Let me apologize for the poorly formatted result set now, new to the forum and not sure how to format, but the underlined values(cDigitsDialed) are the ones I am trying...

Let me apologize for the poorly formatted result set now, new to the forum and not sure how to format, but the underlined values(cDigitsDialed) are the ones I am trying...

These are phone numbers, and I am using them to determine if it is a inbound call or outbound,

For example....

3333 917899999 3210

3333 is the extension the call came into...

This doesn't work for what I am wanting, it is counting the spaces, It doesn't count the characters before the spaces, as you see in the data below for 5...It...

Anyone know how to do this, or maybe a link that gives a example of something close?

I hope this is better??? Thank you for assistance in advance...

CREATE TABLE [dbo].[DICE_GLDDTAAC](

[ACCT_CODE] [varchar](15) NULL,

[DETL_PERIOD] [varchar](2) NULL,

[DETL_POSTING_DATE] [datetime] NULL,

[DETL_TRAN_NUM] [decimal](5, 0) NULL,

[DETL_SOURCE_JRL] [varchar](4) NULL,

[DETL_POSTING_REF] [varchar](10) NULL,

[DETL_DESC] [varchar](40) NULL,

[DETL_LAST_OPER] [varchar](3) NULL

)...