Post reply

Selecting any 3 Characters

  • December 10, 2008 at 8:41 am

    #196905

    Simple question....

    I want to do a SELECT against a table where the column has 3 Characters only.

    e.g.

    Column 1

    456561

    561561

    4565

    641

    1561

    56156

    156

    156

    156

    4564

    56156

    156156156156

    156156156

  • December 10, 2008 at 9:02 am

    #910451

    Go to Book Online and look up the LEN() command.

    I think you will find that helpful.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • December 10, 2008 at 9:11 am

    #910461

    Thanks found it else where:

    Len(clientid) = 3

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

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