By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,511 Members | 1,175 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,511 IT Pros & Developers. It's quick & easy.

how to remove some text part from field in table thru query

P: 1
In our database field name conatains Mr. Mrs. Miss ect which we want to remove thru query

Please help me in writing such query
Mar 17 '14 #1
Share this Question
Share on Google+
2 Replies


zmbd
Expert Mod 5K+
P: 5,397
You need to be exact with your terminology;
Field name = the name of the field in the data table - what you see in the design view of the table.

So, do you need to change the DATA in the table so that you can remove the "Mr, Mrs, Mr., Mrs."

OR

do you need to change the name of the field in the datatable?
Mar 17 '14 #2

NeoPa
Expert Mod 15k+
P: 31,768
This is exactly why the design of the tables is so important. It's really easy to add atomic fields together to get the required results. Much less easy to split them up. Don't store information together in a field if you need it separately.

That said, if the data follows certain rules then it can usually be manipulated. To help you manipulate the data we'd need, at the very least, a clear description of any rules you expect the data to follow.
Mar 17 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.