nuBuilder Forum

I'm creating a user id based on the first three letters of the first and last name and the last 3 characters of the ID field -- Select UPPER (concat(left(userlastname,3), left(userfirstname,3), right(user_id,3))) as 'Gateway_User_Id' from user -- I've tried in vain to place it correctly to create and fillin the appropriate field -- when I show the form nothing happens or I get a SQL error stating the query is incorrect -- the query executes fine in when run in the database -- I'm new to nuBuilder so don't slam me to hard --