question

mahi222 avatar image
mahi222 asked

i need to get substring data

Cloumnname James Mizell- EA due April- Left vm and sent mtg invite Spoke with Savuth of Prosum. John Chow no longer handles that account. I have a data in columns like this and I want to fetch only names the answer is like James Mizell John Chow Please help me on this
functionssubstring
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you provide some details? It is not at all clear what you are trying to do here. Is that two rows or one? You should take a look at this article. http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
0 Likes 0 ·

1 Answer

·
David Wimbush avatar image
David Wimbush answered
Do you have a finite list of people whose names might be in this data? For example do you just need to look for names of people in your organization? If you have a list you could compare it with the text but otherwise, I think this is impossible.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.