Field Size on Query

• ROCKO

  SSC-Addicted

  Points: 429

  More actions

  June 30, 2003 at 3:59 pm

  #82788

  How do I add a filed size to the field named [WILD CARD].

  It set the value in the quesy to 8000 .

  Thanks.Rocko

  SELECT Distinct

  TOP 100 PERCENT [Vin 8], REPLACE(LEFT([Vin 8], 8), ' ', '_') AS [Wild Card]

• July 3, 2003 at 8:00 am

  This was removed by the editor as SPAM

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  July 4, 2003 at 7:17 am

  #464185

  Do you mean this

  SELECT Distinct 
  
  TOP 100 PERCENT [vinnumber], CAST(REPLACE(LEFT([vinnumber], 8), ' ', '_') AS CHAR(8)) AS [Wild Card] 
  
   

  Edited by - davidburrows on 07/04/2003 07:17:36 AM

  Far away is close at hand in the images of elsewhere.
  Anon.