is it Possible?

Results 1 to 3 of 3

Thread: is it Possible?

  1. #1
    Join Date
    Dec 1969

    Default is it Possible?

    Is it possible to get the number of characters in a field of data?<BR><BR>What I&#039;m trying to do is to show only does records in a db whose width of characters is less than 10 characters.. and show only those who are less than 10 characters.?<BR><BR>is that possible to do?

  2. #2
    Join Date
    Dec 1969

    Default What Database? <eop>


  3. #3
    Join Date
    Dec 1969

    Default Two ways...

    You could filter in asp or sql...<BR><BR>I personally would only select those records where the length is &#062; 10...<BR><BR>SELECT Field1, Field2, FieldN FROM MyTable WHERE LEN(Field1) &#060; 10<BR><BR>You could also just select your records and filter via asp...<BR><BR>Do While Not rs.EOF<BR><BR> If Len(Trim(rs("YourField"))) &#060; 10 Then<BR><BR> Output Record<BR><BR> End If<BR><BR> rs.MoveNext<BR><BR>Loop<BR><BR>KLC

Posting Permissions

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