SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict AshleyH's Avatar
    Join Date
    Mar 2005
    Posts
    260
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    selecting first character of a field

    Not sure if this is an SQL thing or if I should be doing this in Coldfusion.

    What I would like to do is select the first character from an entry in a field in a database and show it on the coldfusion page.

    Is this possible with SQL?

    Many thanks
    Ashley

  2. #2
    SitePoint Wizard jimbo_dk's Avatar
    Join Date
    May 2005
    Location
    Singapore
    Posts
    1,261
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can use LEFT(yourField, 1) in SQL.
    Winners Respond. Losers React.
    Singapore Web Designer


Bookmarks

Posting Permissions

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