Results 1 to 2 of 2

Thread: help

  1. #1
    Join Date
    Jun 2004

    Unanswered: help

    I have a field name "Number" in my table .. I want a fix value "S" to be display .. while user need to enter only a number to make it S1, S2, S3, etc.. anyone can teach me

  2. #2
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    Select 'S' & Number
    from tableA


    Insert into tableA values ('S' & 5)
    Last edited by r123456; 11-16-04 at 03:49.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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