Limit text in field in Pass through query

[dagreat1mon]

?Anyone know how to Limit the number of characters in a field?

Hi all,

Does anybody out there know how to limit the amount of characters given in a field in a pass through query? I only want the first 5 characters of a field in a pass through query.

For example some typical records would be: '01123, 01123'
'01237, 01237'
'11754, 11754'

But I would like it to be displayed as: '01123'
'01237'
'11754'

The data is recorded twice due to the way it is set up in the database, however I only want it to be displayed once. I was thinking there must be some code or a workaround out there that would just display the first 5 characters for me (i.e. '01123' instead of '01123, 01123'), but have had no luck in finding a solution! Any ideas?

Cheers

 

[baldeagle]

The data is recorded twice due to the way it is set up in the database, however I only want it to be displayed once. I was thinking there must be some code or a workaround out there that would just display the first 5 characters for me (i.e. '01123' instead of '01123, 01123'), but have had no luck in finding a solution! Any ideas?

In excel, you would use the LEFT keyword.
Left(String,Number of characters)...
try something like that.

 

[dagreat1mon]

Nice one dude, has worked a treat, cant believe how long i was looking for that!