Hi,

> in Mysql i can write something like this:
> UPDATE mysql.user SET Password=PASSWORD('newpass')
>
> in Firebird i get this:
> ErrMsg :
> Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char
> 54 PASSWORD ErrCode : -104

Firebird doesn't have a build in "PASSWORD" function.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com

> when i write this:
> SELECT * FROM utilizatori WHERE id = "x" AND pass = PASSWORD("x")
>
> if someone knows how to solve this please answer
> Thank You