I created a combobox on a form, and setup project data source connection,
carted a table, a view for the table:
create view vw_Favorite as select code + '=:' + value from codetable where
codetablename= 'Favorite' and sequence > 0

that went fine except it adds top (10) percent after select. I then proceed
to set data binding on the combo box, I just could not point it to the view
and get the desired result.  however if I create a stored procedure, I was
able to see one row in the combobox when I run the form

what have I missed?

VB studio express 2005

-------------- the sp is defined as:

CREATE PROCEDURE dbo.FinCoUrl
as
SELECT     code + '+:' + value AS Addr
FROM         CodeTable
WHERE     (codeTableName = 'FinCoUrl') AND (sequence > 0)

/* SET NOCOUNT ON */
RETURN

create procedure sp_favorite as select code