string function?

  • Thread starter Thread starter r
  • Start date Start date
R

r

Is there a string function that will allow me to, for example, pull
positions 5 through 20 of a particular field in a table - I'd prefer to do
it in a query. Is possible?
 
Is there a string function that will allow me to, for example, pull
positions 5 through 20 of a particular field in a table - I'd prefer to do
it in a query. Is possible?
Click to expand...

NewColumn:Mid([FieldName],5,16)

will return 16 characters starting at position #5.
 
THANK YOU! I've been digging through stuff on the web with no luck...
very much appreciated!


fredg said:
Is there a string function that will allow me to, for example, pull
positions 5 through 20 of a particular field in a table - I'd prefer to do
it in a query. Is possible?
Click to expand...

NewColumn:Mid([FieldName],5,16)

will return 16 characters starting at position #5.
Click to expand...
 
Back
Top