View trouble

• • Reply

  14 years ago

  by EricT

  Eric Truter

  , Saudi Arabia

  Joined 15 years ago

  The following code snippet is a view I'm accessing to display specific details in a treeview, built from two tables.
  
  
  SELECT Clients.ClientNumber + ',' + Clients.Lastname + ', ' + Clients.Firstname + '(' + Contract.ContractType + ')' AS Treeview_Name, Clients.IDNumber AS IDNumber
  FROM Clients INNER JOIN Contract ON Clients.IDNumber = Contract.IDNumber;
  
  
  Clients.ClientNumber is an AutoIncremented Integer type and the rest is all string values. My question is how can I convert or cast the ClientNumber to a string so that the view executes correctly without an error?
  
  
  
  
  
  

  Report abuse