Post reply

Multiple Initials

  • November 5, 2009 at 7:38 am

    #71881

    Hi there,

    I have a Initials field in my database.

    What I want to report on is anything that has more than 1 initial (1 character) in the Initials Field.

    So if they had RK or R K or RPK (and so forth) they would come up on my report.

    Thanks for your help.

  • November 5, 2009 at 8:14 am

    #1075375

    Something like this maybe?

    select *

    from dbo.MyTable

    where len(initials)>1;

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • November 9, 2009 at 2:44 am

    #1076548

    Thank you very much. Just what I was after

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply