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

Need Help Query

P: n/a
HB2
I need to remove the first first characters of a text field in a database.

Thanks for any help.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
the function to use is right([field], Len([field])-2)

field = your fieldname
Len = number of characters in string
right = see help
2 = the number of characters you would like to chop-off

Let me know if this enough

Nicolaas

"HB2" <bg******@comcast.net> wrote in message
news:Tpyqc.76609$iF6.6430711@attbi_s02...
I need to remove the first first characters of a text field in a database.

Thanks for any help.

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
Nov 12 '05 #2

P: n/a
HB2
tHANKS!!

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:Cs*******************@news.xtra.co.nz...
the function to use is right([field], Len([field])-2)

field = your fieldname
Len = number of characters in string
right = see help
2 = the number of characters you would like to chop-off

Let me know if this enough

Nicolaas

"HB2" <bg******@comcast.net> wrote in message
news:Tpyqc.76609$iF6.6430711@attbi_s02...
I need to remove the first first characters of a text field in a database.
Thanks for any help.

---
Please immediately let us know (by phone or return email) if (a) this

email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

Nov 12 '05 #3

P: n/a
ams
How cool is that. I was looking for something similar.
ams

"HB2" <bg******@comcast.net> wrote in message
news:6Iyqc.76746$iF6.6441296@attbi_s02...
tHANKS!!

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:Cs*******************@news.xtra.co.nz...
the function to use is right([field], Len([field])-2)

field = your fieldname
Len = number of characters in string
right = see help
2 = the number of characters you would like to chop-off

Let me know if this enough

Nicolaas

"HB2" <bg******@comcast.net> wrote in message
news:Tpyqc.76609$iF6.6430711@attbi_s02...
I need to remove the first first characters of a text field in a database.
Thanks for any help.

---
Please immediately let us know (by phone or return email) if (a) this

email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.