Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
DBISAM Technical Support
»
Support Forums
»
DBISAM SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
where on a calculated field
Thu, May 10 2007 11:47 AM
Permanent Link
Carlos
select lastnames, length(lastnames) as len
from pat
where len>4
I know that that the where statement need to be change.
Thu, May 10 2007 12:09 PM
Permanent Link
"Jose Eduardo Helminsky"
Carlos
<<
select lastnames, length(lastnames) as len
from pat
where len>4
>>
You have to repeat the expression at the where clause
select lastnames, length(lastnames) as len
from pat
where length(lastnames)>4
Eduardo