title: Using a SQL Function to Format Account info?
body: <p>I have a SQL function that I am calling in my VB.Net code within a display function.  The SQL function will format my account data to include the following results form a Table.</p>
  
  <p>The table data:  "001000011121"  (this is the type of structure the data has before formated)
  So the data table data and vb Properties would be called Myaccount, HerAccount, ThisAccount.</p>
  
  <p>Once the data is pulled and then formatted in the VB.net code it will result into a GridDisplay as as: "001.00.001.1121"</p>
  
  <p>The way I have my Public Function in my code is: </p>
  
  <pre><code>Public Funcion GetDisplay(_
  ByVal dbBass as DataProvider_
  ,ByVal pps AS TMGDatarequestParms_
  ,By filter As IFilter_
  ) As Ilist
  
  Dim strobe As String = CType(parms.OptionalParameters,  DataProvider).Database
  
  Dim sql As BiGSqlBuilder(TABLE)
  sql.Select = String.Format("ID, [{0}].dbo.GLForamtAcct(Myaccount) AS [Myaccount], [{0}].dbo.GLFormatAccount(HerAccount) AS [HerAccount], [{0}].dbo.GLFormatAccount(ThisAccount) AS [ThisAccount]", strobe)
  </code></pre>
  
  <p>I left out some of the return code since not necessary.  The only thing I'm concerned is how to format the SQL within the VB.net Code above.  I hope this makes sense I'm new to this whole abstraction stuff.  Any help would be Highly appreciated cause I'm pretty sure how I have it above does not work.</p>