query to select first 30 characters

[KenshiroUK]

Hi all,

Please can I have the command to select first 30 characters in a simple select query.

 

[pr2-eugin]

What about Left([theFieldName], 30) or Mid([fieldName], 1, 30)

But make sure that the Fields do not contain Null Values.. Else it will throw error..

 

[KenshiroUK]

What about Left([theFieldName], 30) or Mid([fieldName], 1, 30)

But make sure that the Fields do not contain Null Values.. Else it will throw error..

Does this also include spaces?

 

[mdlueck]

Does this also include spaces?

Left 30 characters are ANY character, not "excluding spaces or or or..."