Easy Question

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  March 18, 2003 at 10:15 am

  #80488

  On SS7.0, I have a table called persons with FirstName varchar(25) and LastName varchar(25).

  I need to retrieve all the records in that table with the last name O'Malley. How do I do that? Is it:

  SELECT * FROM PERSONS WHERE LASTNAME = 'O''Malley';

  Just want to confirm. I don't have SS7.0 on my machine but I cannot verify this.

  Thanks in advance,

  Billy

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  March 18, 2003 at 10:37 am

  #451359

  Try this:

  DECLARE @Lastname VARCHAR(25)

  SELECT @LastName = 'O'+''''+'Malley'

  SELECT * FROM PERSONS WHERE LASTNAME = @LastName

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  March 18, 2003 at 10:50 am

  #451360

  quote:

  ---

  SELECT * FROM PERSONS WHERE LASTNAME = 'O''Malley';

  ---

  Correct.

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/