Characters limit

[João Crespo]

Can anyone help me to do a query that limit the number of characters for
display.

For exemple i have a filed with 2000 characters and i just want display the
first 300 characters. is that possible?

thanks

 

[MD Websunlimited]

Assuming Access

SELECT Left([ValLong],10) AS FirstTen
FROM table1;

Returns the first 10 characters from the field.

 

[João Crespo]

Tanks it works.
Is it possible limit the number of word not characters too?

Assuming Access

SELECT Left([ValLong],10) AS FirstTen
FROM table1;

Returns the first 10 characters from the field.
--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 Released Special Pricing
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible

Can anyone help me to do a query that limit the number of characters for
display.

For exemple i have a filed with 2000 characters and i just want display
the
first 300 characters. is that possible?

thanks

 

[Stefan B Rusynko]

You would have to count spaces to determine what a word is

--




| Tanks it works.
| Is it possible limit the number of word not characters too?
|
| "MD Websunlimited" <[email protected]> escreveu na mensagem
| | > Assuming Access
| >
| > SELECT Left([ValLong],10) AS FirstTen
| > FROM table1;
| >
| > Returns the first 10 characters from the field.
| > --
| > Mike -- FrontPage MVP '97-'02
| > J-Bots 2004 Released Special Pricing
| > http://www.websunlimited.com
| > FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
| >
| >
| > | >> Can anyone help me to do a query that limit the number of characters for
| >> display.
| >>
| >> For exemple i have a filed with 2000 characters and i just want display
| >> the
| >> first 300 characters. is that possible?
| >>
| >> thanks
| >>
| >>
| >>
| >
| >
|
|