Sql select problem

Results 1 to 2 of 2

Thread: Sql select problem

  1. #1
    Join Date
    Dec 1969

    Default Sql select problem

    Hi <BR><BR>I need some help with an sql statement<BR><BR>I need to create a SELECT statement which will return all records in which the first three letters of the name field equal some value<BR><BR>ie SELECT * from shares WHERE firstname ="abb"<BR><BR>would return all the records in which the first 3 letters of the firstname field is equal to abb.<BR><BR>The database I&#039;m using is SQL server 7 (ie T-SQL)<BR><BR>Can anyone help with this<BR><BR>thanks<BR>Jonny

  2. #2
    Join Date
    Dec 1969

    Default DO NOT REPOST!!!

    That is *VERY* bad netiquette! Especially when you repost less than 2 hours later!<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts