selecting records greater than (string)

[Rodolfo Fontes]

Hi group,

I've done the following quey:
SELECT [T Produtos_Itens].[Part#F]
FROM [T Produtos_Itens]
WHERE ((Len("part#F")>"15"));

But it's not selecting the strings greater than 15 caracters.. How can i do
that?

Thanks,
Rodolfo Fontes

 

[Rodolfo Fontes]

Thanks Allen.

I've been more than once on this situation...
Should I change the SQL to the querie make i want?
Or can i use the Structure mode?

Try:
WHERE Len([T Produtos_Itens].[Part#F]) > 15;

Your current WHERE clause is testing the length of the literal string
"part#F" (yields the numeric value 6) with the string value "15" (string,
because you have it in quotes).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi group,

I've done the following quey:
SELECT [T Produtos_Itens].[Part#F]
FROM [T Produtos_Itens]
WHERE ((Len("part#F")>"15"));

But it's not selecting the strings greater than 15 caracters.. How can i
do that?

Thanks,
Rodolfo Fontes

 

[Allen Browne]

Try:
WHERE Len([T Produtos_Itens].[Part#F]) > 15;

Your current WHERE clause is testing the length of the literal string
"part#F" (yields the numeric value 6) with the string value "15" (string,
because you have it in quotes).

 

[Allen Browne]

Whichever is easiest.

Simplest might be to go into SQL View (View menu, from query design), and
set up the WHERE clause. You can then switch back to Design view, and see
how it would appear there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen.

I've been more than once on this situation...
Should I change the SQL to the querie make i want?
Or can i use the Structure mode?

Try:
WHERE Len([T Produtos_Itens].[Part#F]) > 15;

Your current WHERE clause is testing the length of the literal string
"part#F" (yields the numeric value 6) with the string value "15" (string,
because you have it in quotes).

Hi group,

I've done the following quey:
SELECT [T Produtos_Itens].[Part#F]
FROM [T Produtos_Itens]
WHERE ((Len("part#F")>"15"));

But it's not selecting the strings greater than 15 caracters.. How can i
do that?

Thanks,
Rodolfo Fontes