SELECT * FROM myTable WHERE myFieldName LIKE 'integer' and length(myFieldName) = 2

[Ruslan Zasukhin]

On 12/9/05 9:27 PM, "jacques perconte" <trash at technart.net> wrote:

Hi Jacques, 

> Hi all,
> is it possible to use the length function in an where clause like this:
> 
> SELECT * FROM myTable WHERE myFieldName LIKE 'integer' and
> length(myFieldName) = 2
> 
> In case of not, is there some other possibility to check the length of an
> field in a where clause?

If you use Valentina 2.x then YES

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]