That was it. Thanks Hello Raymond D'Anjou, > Is this what you want: > select @param1 = value1, @param2 = value2, @param3 = value3 from table > where > UID = ID > "Sean Bolster" wrote in message > news:49c0a3379b558ca8945475b1038@news.easynews.com... > >> I had a questions about assigning values to parameters. >> >> If I have say 3 parameters I wanted to fill from a table row what >> would be the syntax. >> >> @param1 >> @param2 >> @param3 >> I want to assign values with a query that will return 1 row like >> select value1, value2, value3 from table where UID = ID >> >> I tried selct into but that didn't work. I'm guessing that select >> into only works with tables. >>
