Question about select as database query.

• sepich.eric

  Say Hey Kid

  Points: 683

  More actions

  December 17, 2011 at 10:09 pm

  #391153

  I have an existing query that looks like this:

  SELECT kingshocks.[Partnumber] AS sku

  FROM kingshocks;

  What I would like to do is something like this:

  SELECT kingshocks.[Partnumber] AS sku,

  "Default" AS store,

  FROM kingshocks;

  What I mean to do is return a column called store with the word "Default" in all the rows that are returned. Does anyone know how this would be done with SQL?

  Thanks!

• subbu1

  Hall of Fame

  Points: 3281

  More actions

  December 17, 2011 at 11:53 pm

  #1422886

  pls try beloe code

  SELECT kingshocks.[Partnumber] AS sku,

  'Default' AS store,

  FROM kingshocks