You can just use a variable

gcNext_Uniq = 451001830
UPDATE suniq ;
 SET nextuniq = gcNext_Uniq ;
 WHERE TblName = 'Studemo'

BTW, there's no reason to use public variables in your programs.

>Hello Group,
>
>I would like to use a variable in an update SQL
>
>Public gcNext_Uniq
>
>gcNext_Uniq = 451001830
>
> UPDATE suniq;
> SET nextuniq = &gcNext_Uniq;
>WHERE TblName = 'Studemo'
>
>Doesn't work.
>
>How do I get the SQL to take a parameter?
>
> UPDATE suniq;
> SET nextuniq = 451001830;
>WHERE TblName = 'Studemo'
>
>Works fine
>
>Thanks much
>Jim