Parsing data in memo field

  • Thread starter Thread starter Ademar
  • Start date Start date
A

Ademar

I have an MS Access database linked to a SQL table. I'm creating a query in
Access that returns a column of type "ntext" with length "16". I'm not sure
what that data type means but it looks to me like a Memo field. The field
name is "ContactInfo". In that field there is chunks of data separated by
double carriage returns. I need to convert those carriage returns into
columns in the query. Is there a SQL Query Function in Access that I can
use to accomplish this? How would I plug it in to the following query:


SELECT dbo__SupportLog.ContactInfo
FROM dbo__SupportLog;


Thanks,
Ademar.
 
Figured it out. Thanks anyway.

Expr1:
trim(Mid([dbo__SupportLog].[ContactInfo],InStr(1,[dbo__SupportLog].[ContactInfo],Chr$(13))+2,InStr(3,[dbo__SupportLog].[ContactInfo],Chr$(13))))
 
Back
Top