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.

seanlange avatar image seanlange commented ·
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.