MSSQL to ACCESS Problems

[Keenan]

Hi

I have a access data base with a event title field and wish to only
return say 20 characters, BUT I need it to return to the last space so
If the field contained

"The Shrewsbury" Flower Show the result would be "The Shrewsbury"

I have done this code in mssql but doesnt work in access here is the
code I used

Select LEFT(DB_Field, CHARINDEX(' ', DB_Field, 50) ) as DB_Field
from dbo.DATABASE

Thanks In advance!!

[Larry Linson]

Check Help on the Left and InStr functions in Access.

"Keenan" <ni**@21stcd.com> wrote in message
news:55**************************@posting.google.c om...

Hi

I have a access data base with a event title field and wish to only
return say 20 characters, BUT I need it to return to the last space so
If the field contained

"The Shrewsbury" Flower Show the result would be "The Shrewsbury"

I have done this code in mssql but doesnt work in access here is the
code I used

Select LEFT(DB_Field, CHARINDEX(' ', DB_Field, 50) ) as DB_Field
from dbo.DATABASE

Thanks In advance!!