Featured post
LinQ Substring Function From the Right -
im new linq , i've got problem
question: if have string example "mystring"and need characters @ positions 5 , 6 counting right of string, ie: "st"
here's query
dim result = everyval in allvals everyval.substring(5,2)='st' select everyval.name
now wont return correct values database because default consideration of positions in substring function left right. 1 solution maybe reverse string , apply substring function it. how should doing this?
can tell me..???
this rather strange requirement, indexof/contains
enough this. however, try (conceptually) truncating value , testing end using endswith
.
something perhaps (untested , doesn't work):
dim result = everyval in allvals everyval.remove(4).endswidth("st")
msdn nicely lists string functions can safely translated sql linq: http://msdn.microsoft.com/en-us/vbasic/bb688085
- Get link
- X
- Other Apps
Comments
Post a Comment